Skip to content

Registered aircraft · 72,010

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4651JReznik Real Estate LLC · Belton, SCBuilt 1968 · S/N 28R-30545 N46521Shadow Yacht LLC · Reno, NVBuilt 1968 · S/N 17257322 N46525Yarnall Paul J · Canandaigua, NYBuilt 1968 · S/N 17257326 N46526Bluebird Aviation LLC · Arrington, TNBuilt 1968 · S/N 17257327 N46528Petaloutha Aero Corp · Wilmington, DEBuilt 2010 · S/N 103 N46529Toledo City School District · Toledo, OHBuilt 1968 · S/N 17257329 N4652GMika Joseph P · Sierra Vista, AZBuilt 1979 · S/N 17273278 N4652RSpringfield Flying Club Inc · Ludlow, VTS/N 28-21407 N4652YDakota Acre Farms Inc · Denhoff, NDBuilt 1967 · S/N 25-4372 N46530Ward Michael C · Fort Worth, TXBuilt 1968 · S/N 17257330 N46531Gann Rick L · Lafayette, TNBuilt 1968 · S/N 17257331 N46532Obx Airplanes LLC · Manteo, NCBuilt 1968 · S/N 17257332 N46534Fendley Bobby G · Seneca, SCS/N 17257334 N46539Jsc Consulting Group LLC · Norwich, NYBuilt 1968 · S/N 17257337 N4653JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30547 N4653RElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 28-21408 N4653VMouton Charles J · Gladewater, TXBuilt 1980 · S/N 172RG0347 N4653XRankin Kevin · Maryville, MOBuilt 1966 · S/N 15064703 N46540Van Sambeek Francene S · Vinemont, ALBuilt 1968 · S/N 17257338 N46543Dollarhide Lawrence P · Huntsville, ALBuilt 1968 · S/N 17257340 N46549Registration Pending · Abilene, TXRegistration pendingBuilt 1968 · S/N 17257344 N4654RBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 28-21409 N4654TParthemore Terry L II · North Bend, ORS/N R18201726 N46550Taylor Timothy A · Justin, TXBuilt 1968 · S/N 17257345 N46551Strandberg James S · Anchorage, AKBuilt 1968 · S/N 17257346 N46552Cache Rentals 401k P S P LLC · Greeley, COBuilt 1968 · S/N 17257347 N46556Bbh Aviation LLC · Peachtree City, GABuilt 1968 · S/N 17257348 N4655JCody Martell Racing Inc · Fort Myers, FLS/N 28R-30549 N4655RFroeschl Christopher J · Roanoke, VABuilt 1966 · S/N 28-21410 N4655WAeroflyin Corp · Miramar, FLBuilt 1977 · S/N 13185 N46567Hullquist Claude G · Ringgold, GABuilt 1968 · S/N 17257355 N4656JPeters David E · Sylvania, OHBuilt 1968 · S/N 28R-30550 N4656RSheremeta David T · Beverly Hills, FLBuilt 1968 · S/N 28-24834 N4656VWest Riverbend LLC · Washington, MOS/N 172RG0348 N46570Nied Rossana C · Duarte, CABuilt 1968 · S/N 17257358 N4657GFlorida Flight Training Center Inc · Venice, FLBuilt 1979 · S/N 17273283 N4657JHummel Aileen J · Fort Worth, TXBuilt 1968 · S/N 28R-30551 N4657QSaddle Mountain LLC · Cave Creek, AZBuilt 1973 · S/N 17261738 N4657SXyz Aircraft LLC · Albuquerque, NMBuilt 1979 · S/N R18201369 N46581Gatlin Jason B · Athens, ALBuilt 1968 · S/N 17257366 N46584Rizzo Joseph V · Binghamton, NYBuilt 1968 · S/N 17257369 N46586Hardin Thomas E · Bardstown, KYBuilt 1968 · S/N 17257370 N4658RRegistration Pending · Sand Springs, OKRegistration pendingBuilt 1966 · S/N 28-21413 N4658WRehberg Michael C · Albuquerque, NMBuilt 1977 · S/N 13188 N46593Grupo Cuaahtemoc LLC · Canutillo, TXBuilt 1968 · S/N 17257372 N4659G4659g LLC · Wheeling, ILBuilt 1979 · S/N 17273285 N4659QN4659q Corp · Papillion, NEBuilt 1973 · S/N 17261739 N4659RSchmitt Michael T · Danville, ILBuilt 1966 · S/N 28-21414 N465ACBlue Super D LLC · Clark, NJBuilt 1999 · S/N 827-99 N465CLuluvg LLC · Kalispell, MTBuilt 2000 · S/N 2067

Back to AD 87-10-06 R1