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.

N20236Safety In Motion Flight Center Inc · Puyallup, WAS/N 17261120 N20238Valenti Jeffery N · Eastport, NYBuilt 1973 · S/N 17261122 N2023ASouthern Cast Products Inc · Meridian, MSBuilt 1978 · S/N TC-2168 N2023CFulps Aviation LLC · Winston Salem, NCBuilt 1979 · S/N TH-1012 N2023KJuliet Foxtrot LLC · Scott City, KSBuilt 1978 · S/N TC-2169 N2023LStearns Ramsey Aviation LLC · Brooten, MNBuilt 1978 · S/N CE-802 N2023RWhitehurst Brian P Trustee · Crossville, TNBuilt 1969 · S/N 28-5430 N2023WSpecialty Extrusion Marketing Co Inc · Dover, DEBuilt 1965 · S/N TC-971 N2023XZim Sim LLC · Charleston, SCBuilt 1965 · S/N 18256123 N2023YCassero Ronald V · Santa Rosa, CABuilt 1962 · S/N 17249523 N2023ZSchulert Peter · Lebanon, TNS/N TC-2171 N20241Aviation 241 Inc · North Lima, OHBuilt 1972 · S/N 17261124 N20242Gent John F · Wellman, IABuilt 1972 · S/N 17261125 N20243Webb John W · Elkins, WVBuilt 1972 · S/N 17261126 N20246Olek Brad · New Richmond, WIBuilt 1972 · S/N 17261127 N20247Grace Ellen M · Bloomville, NYBuilt 1972 · S/N 17261128 N2024ANew Heights Aviation LLC · Waxhaw, NCFirst renewal noticeBuilt 1978 · S/N CE-804 N2024CD M S Leasing Co LLC · Las Vegas, NVBuilt 1959 · S/N TD-198 N2024GPerry Scott D · Hood River, ORBuilt 1978 · S/N D-10162 N2024KB2s Aviation LLC · Billings, MTBuilt 1978 · S/N D-10164 N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1 N2024QFoose John L Trustee · Sammamish, WABuilt 1978 · S/N E-1339 N2024RStorm David A · Lowell, ARBuilt 1969 · S/N 28-5432 N2024SRegistration Pending · Sublette, KSRegistration pendingS/N R18201285 N2024VWhiskey Tango Flyers Inc · Middletown, DEBuilt 1978 · S/N D-10165 N2024WMunn Jeffrey R · Auburn, NYBuilt 1966 · S/N D-8078 N2024XMahaney Nicholas · Tahlequah, OKBuilt 1965 · S/N 18256124 N20250Kooistra Samuel R · Honobia, OKBuilt 1972 · S/N 17261131 N20251Granahan Eric J · Burlington, WIBuilt 1972 · S/N 17261132 N20252Morino William D · Palos Verdes Est, CABuilt 1981 · S/N 18053183 N20259Mackin Robert Michael · Castro Valley, CABuilt 1972 · S/N 17261136 N2025NA B C Leasing Inc · Oakdale, LABuilt 1978 · S/N E-1336 N2025YMarine Resources Inc · Gilbert, AZS/N 17249525 N20262Sherman Aviation Inc · Redmond, ORBuilt 1972 · S/N 17261138 N20264Moltz Larry D · Seguin, TXBuilt 1972 · S/N 17261140 N20267Knot Grounded Aviation LLC · Napanoch, NYBuilt 1972 · S/N 17261143 N20268Fox Two LLC · Camino, CABuilt 1972 · S/N 17261144 N2026CSkys Aircraft Corp · Newnan, GABuilt 1959 · S/N TD-193 N2026DToro Miguel Angel · San Ysidro, CABuilt 1952 · S/N D-3377 N2026WGta Air Inc · Addison, TXBuilt 1978 · S/N TH-976 N2026XGonzales Alvin S · Mount Prospect, ILBuilt 1965 · S/N 18256126 N20270River Town Aviation LLC · Williamstown, WVBuilt 1972 · S/N 17261146 N20272First Class Flying Club LLC · Centennial, COBuilt 1972 · S/N 17261148 N20278Cooke Jerald B · Bowie, AZBuilt 1972 · S/N 17261153 N20279Echevestre Yafet Rivera · Camuy, PRBuilt 1972 · S/N 17261154 N2027DNichols Neil A · Aalachicola, FLBuilt 1978 · S/N TH-974 N2027GCloudsight LLC · Surfside, FLBuilt 1958 · S/N 51327 N2027RSinko James W · Menlo Park, CABuilt 1964 · S/N 18255227 N2027UJpb Diversified LLC · Auburndale, FLBuilt 1978 · S/N TH-964 N2027WMckinney Karen L · Naperville, ILS/N CD-976

Back to AD 98-21-21 R1