Skip to content

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N16372Blue Bird Aviation LLC · Zephyr Cove, NVBuilt 1973 · S/N 32-7340083 N16374Milliard Craig R · Benicia, CABuilt 1973 · S/N 28-7305238 N16377Jones Aaron M · Conrad, MTBuilt 1973 · S/N 28-7310092 N16378Lapair Inc · Vero Beach, FLBuilt 1973 · S/N 32-7300026 N1637CAshby Clark S · Pleasant Grove, UTBuilt 1953 · S/N 30337 N1637EJag Flying Club Inc · Morgantown, WVBuilt 1978 · S/N 17271077 N1637FLaminar Skies Aviation LLC · Broken Arrow, OKS/N 17255032 N1637HGross Leslie W · Perry, MES/N 28-7716030 N1637YSmartt Kevin M · Springfield, TNBuilt 1962 · S/N 17249337 N16382Reick Gregg G · Minnesota City, MNBuilt 1973 · S/N 28-7325259 N16385Haines Michael C · Wadsworth, OHBuilt 1973 · S/N 28-7305242 N16387Anderson Jeffrey J · Hartland, WIBuilt 1973 · S/N 28-7310093 N1638FKeith Frye · El Dorado, KSS/N 17255033 N1638HKaczmarek James J Jr · Parksley, VABuilt 1977 · S/N 28-7716032 N1638JSmith Bryan Alexander · Cabot, ARBuilt 1967 · S/N 28-24026 N16393Parker Owen · Collyer, KSBuilt 1973 · S/N 28-7325264 N16395Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1973 · S/N 28R-7335141 N16396Nobrainer Holdings LLC · Fort Lauderdale, FLBuilt 1973 · S/N 32-7300027 N16398Withers Harry R · Beaufort, SCBuilt 1973 · S/N 28-7305244 N1639DVoigt Don M · Palmer, AKBuilt 1952 · S/N 20281 N1639JAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-24027 N1639WElt Services LLC · Wilmington, DEBuilt 1972 · S/N CD-1295 N163AMRogers Brian D · Pacific, MOBuilt 1968 · S/N 28-5009 N163AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010061 N163CLJust Saying Construction LLC · Merritt Island, FLS/N 21062122 N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210 N163HJ&L Asset Holdings LLC · Biloxi, MSBuilt 1957 · S/N 34049 N163LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842362 N163MCCriddle Michael J · Baker, FLBuilt 1963 · S/N 17250149 N163QGofly Trading LLC · Opa Locka, FLBuilt 1964 · S/N TC-671 N163RHHollis Richard H · Auburn, MES/N 18051307 N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872 N163UHarbaugh Steven K · Austin, TXBuilt 1968 · S/N E-98 N163WDavis Paul J Jr · Springdale, ARBuilt 1956 · S/N 27094 N16402Peters Dale M · Naknek, AKBuilt 1973 · S/N 28-7305245 N16409Pridmore Joshua B · Lubbock, TXBuilt 1973 · S/N 28-7325265 N1640DRoessler Larry J · Groveland, CABuilt 1952 · S/N 20282 N1640EBanan Abdolreza · San Diego, CABuilt 1978 · S/N 17271078 N1640HArcher 1640h LLC · Oscoda, MIS/N 28-7790321 N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221 N1640YHall Justin J · Bellevue, NEBuilt 1962 · S/N 17249340 N16410Cherokee Five LLC · Bakersfield, CABuilt 1973 · S/N 28-7325266 N16412Cherokee N16412 LLC · Peoria, AZBuilt 1973 · S/N 28-7305247 N16415United Aviation LLC · Prospect, KYS/N 32-7340085 N16417Riddle Christopher Joseph · Auburn, CABuilt 1973 · S/N 28-7305249 N16418Hallgren Mitchel T · Sycamore, ILBuilt 1973 · S/N 28-7305250 N16422Ardupilot Inc · Wilmington, DEBuilt 1973 · S/N 28R-7335145 N16425Box Aviation Inc · Montgomery, ALBuilt 1973 · S/N 28-7305251 N16429Hilbish David B · Chicago, ILBuilt 1973 · S/N 28R-7335112 N1642FRomeo Kilo Golf LLC · Asheville, NCBuilt 1966 · S/N 17255037

Back to AD 98-21-21 R1