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.

N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648 N1531WNeo Foot And Ankle Surgery Inc · Miami, OKBuilt 1972 · S/N E-325 N1531ZShenandoah Whalen · Amelia, OHBuilt 1961 · S/N TC-205 N15320Taylormade LLC · Pharr, TXBuilt 1972 · S/N 28-7325038 N15322Ofner Josef P · Canterbury, NHBuilt 1972 · S/N 28-7305056 N15323Coastal Flight Inc · Tierra Verde, FLBuilt 1972 · S/N 28-7305057 N15324Lewis Christopher Dean · Bettendorf, IABuilt 1972 · S/N 28R-7335050 N15327Carey Nicholas Andrew · Glencoe, ILBuilt 1972 · S/N 28-7325040 N1532JRosario Pamela Peralta · Orlando, FLBuilt 1967 · S/N 28-23932 N1532XRaymond Darwin V · Glenwood Springs, COBuilt 1975 · S/N 34-7570275 N1532ZFlying Y Farms LLC · Klamath Falls, ORBuilt 1962 · S/N D-6855 N15334Shuart Bruce E · Wantage, NJBuilt 1972 · S/N 28R-7335051 N1533EPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7350050 N1533JTolmachoff Alex W · Rogers, TXBuilt 1967 · S/N 28-23933 N1533WAtkinson Brandon A · Pageland, SCBuilt 1972 · S/N CD-1285 N1533XBurkhardt Stacie M · Wasilla, AKBuilt 1975 · S/N 28-7505240 N15343Bridger'S Hvac And Welding LLC · Milan, TNBuilt 1972 · S/N 28-7305061 N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038 N1534FDieckman Raymond DBA · Hamilton, MTBuilt 1965 · S/N 185-0877 N1534JChapman Melvin Newton II · Mishawaka, INBuilt 1967 · S/N 28-23934 N1534YLipsmeyer Jason K · Springdale, ARS/N 17249234 N15354Stephen Swift · Justin, TXBuilt 1972 · S/N 28-7305062 N15355Brandvold Larry J · Fairfield, MTBuilt 1972 · S/N 28-7310037 N15358Daffer Jon T · Edgewood, NMBuilt 1972 · S/N 28-7310038 N15359Kobberdahl Matthew T · Maple Grove, MNBuilt 1972 · S/N 28-7325046 N1535SGerard Aircraft Inc · Johnson, KSBuilt 1962 · S/N D-6982 N1535WStark Gary · Riverside, CABuilt 1972 · S/N CE-374 N1535XSmith James E · Wilson, NCBuilt 1975 · S/N 32-7540170 N1535YTheriault John · Harvard, ILBuilt 1962 · S/N 17249235 N1535ZGsp Aviation LLC · Wichita, KSBuilt 1961 · S/N D-6859 N15360Registered aircraftBuilt 1972 · S/N 28-7325047 N15361Williams Darren M · Carthage, ILBuilt 1972 · S/N 28-7305063 N15363Creativity Before Capital LLC · Tampa, FLBuilt 1972 · S/N 28-7310039 N15367Labrousse Ronald E · Tidewater, ORBuilt 1972 · S/N 28-7325048 N1536XClark Christopher · Ormond Beach, FLBuilt 1975 · S/N 34-7570276 N1536YCk Aviation LLC · Williamstown, NJBuilt 1962 · S/N 17249236 N15372Hollingshead Terry L · Flint, MIBuilt 1972 · S/N 28-7325050 N15373Johnson Brant T · Collinsville, OKS/N 28-7325051 N15374Smith William L · Supply, NCS/N 28-7325052 N15376Brown William D Jr · Mount Pleasant, TXBuilt 1972 · S/N 28-7305065 N15377Johnson Matthew · Biglerville, PABuilt 1972 · S/N 28-7305066 N15378Ketcham Jesse E · Aguanga, CABuilt 1973 · S/N 28-7305067 N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053 N1537CWbs Coatings Inc · Grand Junction, COBuilt 1953 · S/N 30237 N1537JYearta Philip T · Bono, ARS/N 28-23938 N1537XSale Reported · Milton, FLSale reportedBuilt 1975 · S/N 28-7515418 N1537YAloha Skies Aviation LLC · Pahoa, HIBuilt 1962 · S/N 17249237 N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054 N15383Nevill Donald L · Clare, MIBuilt 1972 · S/N 32-7300006 N15388Smith John-Michael L · Austin, TXBuilt 1972 · S/N 28-7325054

Back to AD 98-21-21 R1