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.

N20559Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261393 N2055DRegistration Pending · Alvaton, KYRegistration pending, pending cancellationBuilt 1952 · S/N D-3398 N2055EAerowood Aviation LLC · Monroe, NCBuilt 1978 · S/N 17271134 N2055MHarding Lawrence · Santa Monica, CABuilt 1977 · S/N 28R-7837063 N2055PPechacek Justin D · Snyder, TXBuilt 1979 · S/N TC-2235 N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965 N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204 N2055XMartin Robert L Jr · Havana, ILBuilt 1965 · S/N 18256155 N20560Kirkeby Dean A · Clark, SDBuilt 1973 · S/N 17261394 N20565Waters Aero Marine Inc · South Thomaston, MEBuilt 1973 · S/N 17261398 N20567Msl Services Inc · Michiana Shores, INBuilt 1973 · S/N 17261400 N2056DBickert Marshal A · Springfield, VABuilt 1953 · S/N D-3399 N2056EFeauto Aviation LLC · Saint Cloud, FLBuilt 1973 · S/N 17261399 N2056MSteele Shelly Sam · Spicewood, TXBuilt 1977 · S/N 28R-7803102 N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156 N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023 N2056XWhite Christy · Wichita, KSBuilt 1965 · S/N 18256156 N20571Carver Clarence K · Lutz, FLBuilt 1973 · S/N 17261404 N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247 N20575Desanti Arthur Wallace · Ramona, CABuilt 1973 · S/N 17261407 N2057ADesruisseaux Kemens · Clarksville, TNBuilt 1978 · S/N E-1420 N2057GDau William K · Palmer, AKFirst renewal noticeBuilt 1958 · S/N 51357 N2057MSeintec Corp · Aventura, FLBuilt 1977 · S/N 28R-7803103 N2057XLewis Tommy · Winnsboro, TXBuilt 1965 · S/N 18256157 N2057YCable Land Co · Upland, CABuilt 1962 · S/N 17249557 N20589Brown Jennifer L · Vancouver, WABuilt 1973 · S/N 17261421 N2058AFlying J Aviation LLC · Lynden, WABuilt 1979 · S/N TC-2201 N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85 N2058GPiercy Mark W · Lubbock, TXBuilt 1958 · S/N 51358 N2058KCollins Jimmy · Spring, TXBuilt 1979 · S/N TK-66 N2058WSweet Fred A · Loves Park, ILS/N D-8192 N20590Treadwell Donald E · San Angelo, TXBuilt 1973 · S/N 17261422 N20591Vogt Roger D · Visalia, CABuilt 1973 · S/N 17261423 N20592Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17261424 N20593Nieto Marcelo F · Mastic, NYBuilt 1973 · S/N 17261425 N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202 N2059EH & H Aviation Enterprises LLC · Fairfield, OHBuilt 1978 · S/N 17271137 N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159 N2059WMorgan Jeffrey B · Edgewater, FLBuilt 1965 · S/N D-7993 N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994 N2059YOlson Michael J · Kapaa, HIBuilt 1962 · S/N 17249559 N205AAHzl Hanger LLC · Drums, PAS/N 205-0453 N205ADWarner John E · West Redding, CTS/N 24-3037 N205AEBerry Alan J · Danvers, MAS/N 24-3043 N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516 N205AWLee Kevin B · Beulah, NDBuilt 1963 · S/N 205-0522 N205BBHixon George S · San Antonio, TXBuilt 1962 · S/N 205-0060 N205BPRegistered aircraftBuilt 1962 · S/N 205-0089 N205CBBusse Christopher K · Leo, INS/N 24-0983 N205CCHinn Terry A · Hot Springs, SDS/N 24-3044

Back to AD 98-21-21 R1