Skip to content

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.

N1276UStelham Co · Olive Branch, MSBuilt 1976 · S/N 17266971 N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245 N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249 N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250 N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252 N1277DEllison Phillip · Castle Hayne, NCBuilt 1951 · S/N 19853 N1277FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17272982 N1277XDuke City Mooney LLC · Lakewood, COBuilt 1963 · S/N 150 N1277ZKnight Donald R · Merrimack, NHBuilt 1961 · S/N CD-342 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N1278HMetzner Brad · Visalia, CAS/N 34-7770118 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 N1278TSmith Sullivan · Cookeville, TNBuilt 1972 · S/N 28-7225447 N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262 N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263 N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264 N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265 N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266 N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267 N1279GHodgman Gary W · Greenville, TXBuilt 1974 · S/N 310Q1129 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279RSedona Aviation LLC · Sedona, AZS/N 30402 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847 N1279XRegistered aircraftBuilt 1963 · S/N 152 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127BNunneley Ian · Port Saint Joe, FLBuilt 1963 · S/N CD-607 N127FCalifornia In Nice Inc · San Jose, CABuilt 1965 · S/N TC-869 N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343 N127KGardner Victoria S · Port Saint Lucie, FLBuilt 1960 · S/N 17248076 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127MBBerger Max · Daytona Beach, FLBuilt 1976 · S/N 310R0654 N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503 N127MTPilotsplane LLC · Boca Raton, FLBuilt 2003 · S/N 2844094 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N127RWWindmiller David · Melville, NYBuilt 1976 · S/N TC-1958 N127TBTorongo William Martin · Grayling, MIBuilt 1956 · S/N D-4590 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041 N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N1280GSky Aviation And Consulting · Panorama City, CABuilt 1976 · S/N 310R0692 N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253 N1280XErlandson Michael D · Salt Lake City, UTS/N 153 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N1281DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 19857 N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289

Back to AD 98-21-21 R1