Registered aircraft · 85,616

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.

N1221UJ Linn Aviation Inc · Quinlan, TXBuilt 1976 · S/N 17266918 N12229Zapsky Richard M Jr · Houtzdale, PABuilt 1973 · S/N 17261892 N1222FVelocity Sport LLC · Cedar Falls, IABuilt 1975 · S/N 18502784 N1222LBoland Charles R · Blairsville, GABuilt 1969 · S/N 17258385 N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276 N1222TPraniewicz Charles P · New Kensington, PABuilt 1968 · S/N 28R-30582 N1223Munning Joseph H Md · Jasper, INBuilt 1961 · S/N 24-2906 N12232S C Skyhawks Inc · Columbia, SCBuilt 1973 · S/N 17261895 N12234Amelia Reid Aviation LLC · San Jose, CABuilt 1973 · S/N 17261896 N12236Wolak Filip O · New York, NYBuilt 1973 · S/N 17261898 N12239Gables Christopher A · Riverside, CABuilt 1973 · S/N 17261900 N1223UKoren Richard D · Brea, CABuilt 1976 · S/N 17266919 N1223XAirspeed Consulting LLC · Mounds, OKBuilt 1963 · S/N 194 N1223Z2dwh LLC · Katy, TXBuilt 1961 · S/N TC-67 N12240Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261901 N12243Phoenix Sky Aviation LLC · Gilbert, AZBuilt 1973 · S/N 17261903 N12245Donnelly Terrence A · Eleele, HIBuilt 1973 · S/N 17261905 N12246Bowles Thomas M · Olivehurst, CABuilt 1973 · S/N 17261906 N12247Rebecca'S Wings 247 LLC · Greenville, KYBuilt 1973 · S/N 17261907 N1224DByrer Jesse A · Monrovia, INBuilt 1951 · S/N 20114 N1224TAig Aeronautics LLC · Guaynabo, PRBuilt 1999 · S/N 32-57116 N1224UGoss Selby · Baytown, TXBuilt 1976 · S/N 17266920 N1224VCarter John T · Huntington Beach, CABuilt 1952 · S/N 20358 N1224XAlpha Aviation Mission Outreach Center Inc · Muskogee, OKBuilt 1963 · S/N 195 N1225QDupont Larry W · North Hero, VTBuilt 1977 · S/N 18503472 N1225XSuda Inc · Lindsborg, KSBuilt 1963 · S/N 196 N1225ZFree Gregory · Monroe, IABuilt 1961 · S/N D-6692 N12261Davis Danny R · S Coffeyville, OKBuilt 1973 · S/N 17261909 N1226FSnoopys Group Inc · Westerly, RIBuilt 1979 · S/N 17272978 N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269 N1226UAirborne LLC · Wilmington, DEBuilt 1976 · S/N 17266922 N1227DWhite Michael D · Willow Springs, MOBuilt 1950 · S/N 19781 N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789 N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241 N1227UKelly William W · Springfield, ORBuilt 1976 · S/N 17266923 N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198 N1228DBell Stephen R · Carleton, MIBuilt 1950 · S/N 19782 N1228GMcdaniel Dean K · Mesa, AZBuilt 1974 · S/N 310Q1081 N1228MHillsboro Flying Club · Hillsboro, ORBuilt 1975 · S/N 18264247 N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577 N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266 N1228UBig Sky Aviation LLC · Glenmora, LABuilt 1976 · S/N 17266924 N1228ZPate Ronald E · Hilltop Lakes, TXBuilt 1961 · S/N D-6688 N12290Read Andrea · Austin, TXFirst renewal noticeBuilt 1973 · S/N 17261912 N12291Cisek Jason M · Westfield, MABuilt 1973 · S/N 17261913 N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267 N1229UMcdonald Air Services LLC · Saint Johns, MIBuilt 1976 · S/N 17266925 N122AMHarper David · New Richmond, WIBuilt 1973 · S/N 310Q0943 N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N122BRHollon Blake D · Douglas, WYBuilt 1958 · S/N TD-65

Back to AD 98-21-21 R1