Skip to content

Registered aircraft · 81,728

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N300VCReam Real Estate LLC · York, PAS/N 2106 N300VTCarroll James K · Klamath Falls, ORBuilt 1999 · S/N DM0276 N300WEK & S Aero LLC · West Chester, PABuilt 1979 · S/N 32R-7985007 N300WFAmoth Kurt J Trustee · White Salmon, WABuilt 1997 · S/N 18280015 N300WLRosen Robert D · Lewisville, NCBuilt 1977 · S/N 32R-7780474 N300WSOdyssey Aviation LLC · Raleigh, NCBuilt 1992 · S/N 687-92 N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280 N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010GJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeS/N 18013C N3010KGoodwin David · Edinburg, NYBuilt 1978 · S/N 28-7911086 N3010MAtlseimer John C · Ione, CABuilt 1947 · S/N 12-1709 N3010TBb Air Corp · Tulsa, OKBuilt 1979 · S/N 32-7940060 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961 N30112Leonard Kevin J · Wagner, SDBuilt 1968 · S/N 17701066 N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076 N30116Registration Pending · Benson, AZRegistration pendingBuilt 1968 · S/N 17701068 N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N3011KBravo Farm LLC · Dover, DEBuilt 1978 · S/N 32-7940023 N3011NLange Jonathan R · La Mesa, CAS/N 28-7911098 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011XHanania-Stout Motorcars LLC · Chattanooga, TNBuilt 1979 · S/N 32-7940093 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30121Jokerst Kenneth · St Louis, MOBuilt 1968 · S/N 601 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N30128Mizani Air LLC · San Antonio, TXBuilt 1968 · S/N 17701069 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012BThrowbacks LLC · Pueblo, COBuilt 1978 · S/N 28-7911016 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402 N3012LCwp Flight LLC · Lawton, OKBuilt 1979 · S/N 32-7940031 N3012MWatkins Brian D · Vancouver, WAS/N 12-1571 N3012NBirkenseer James J · Danville, CAS/N 28-7911099 N3012ZChase 13 LLC · Wilmington, DEBuilt 1959 · S/N 22-6963 N30133Ts Fliers LLC · Mount Pleasant, MIBuilt 1968 · S/N 17701070 N30139Heinitz Bradford C · Arlington, WAS/N 17701074 N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170 N3013MDavis David N · Haskell, OKBuilt 1947 · S/N 12-1573 N3013NAnderson John · Hollister, CABuilt 1979 · S/N 28-7911100 N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395 N3014B-Line Air LLC · Malcom, IABuilt 2008 · S/N 1961 N30142Marshman Robert M · Murfreesboro, TNBuilt 1968 · S/N 17701075 N30145Keno Aviation LLC · Marshfield, MAS/N 17701077 N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085 N30148Tyler Marion B · Lacey, WABuilt 1968 · S/N 17701079 N3014GWings Aircraft LLC · Anacortes, WABuilt 1978 · S/N 28-7911072 N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182 N3014MBaum James L Trustee · Anchorage, AKBuilt 1947 · S/N 12-1572

Back to AD 81-18-04 R2