Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N12741Wings Of Man Ltd · Wauwatosa, WIBuilt 1973 · S/N 17262221 N12745Gutierrez Benito E · Tehachapi, CABuilt 1974 · S/N 17262224 N12749Daly Paul Kurt Jr · Yucaipa, CABuilt 1973 · S/N 17262228 N1274MGarner Tom Trustee · Agua Dulce, CABuilt 1975 · S/N 18264271 N1274SDiamond E Electrical Services LLC · Bryant, ARBuilt 1976 · S/N 18264842 N1274UVine Clayton A · Wolf Point, MTBuilt 1976 · S/N 17266969 N12750Crosby Flying Services LLC · Fort Worth, TXBuilt 1973 · S/N 17262229 N12751Wyatt Trost LLC · Concordia, KSBuilt 1973 · S/N 17262230 N12753Juliett Papa LLC · Kalispell, MTBuilt 1973 · S/N 17262232 N1275MAdams Charles P · New London, NHBuilt 1970 · S/N 33701275 N1275YGrissom Patrick D · Blanco, TXFirst renewal noticeBuilt 1962 · S/N 15059675 N12760Decker Stephen Lee · Como, COBuilt 1973 · S/N 17262235 N12766Civil Air Patrol Flying Assoc Inc · Branford, CTBuilt 1973 · S/N 17262240 N12767Lipstreu William H · Hudson, OHBuilt 1975 · S/N 17702386 N12768Martin Thomas J · Lynden, WABuilt 1973 · S/N 17262242 N1276DLehr Denis J · Sacramento, CABuilt 1951 · S/N 20124 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 N1277MWilliams Richard A · Brookhaven, GABuilt 1970 · S/N 33701277 N1277WRush Aviation Rentals Inc · Meridian, IDBuilt 2001 · S/N 172S8846 N127826350 LLC · Yorklyn, DES/N 17702387 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846 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 N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272 N1279QCerrit LLC · Helena, MTBuilt 1971 · S/N 15072579 N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847 N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027 N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N127FRYoon Paul · Saint David, AZS/N 17275292 N127HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2003 · S/N 172S9532 N127KGardner Victoria S · Port Saint Lucie, FLBuilt 1960 · S/N 17248076 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127KWElizabeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9827 N127RLSkylane Of Ohio LLC · London, OHS/N 18262910 N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041

Back to AD 79-10-14 R1