Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N775EESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 670348 N775GTToole Gregory Keith · Humble, TXBuilt 1977 · S/N 17268509 N775JPWentworth Philip C II · Nashport, OHBuilt 1979 · S/N 38-79A0884 N775MCAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265008 N775MSSkinner Leasing LLC · Medford, ORS/N R18201294 N775RTG & M Aircraft Inc · Wheat Ridge, COS/N 17273352 N7760GLeriche Nicolette · Oceanside, NYBuilt 1970 · S/N 17259460 N7760MBirdy Aviation LLC · Santa Barbara, CABuilt 1974 · S/N 22-0020 N7762MMunn Kevin · Jeffersonville, INBuilt 1974 · S/N 22-0022 N7763MZimmerman Kurt L · Blacksburg, VABuilt 1974 · S/N 20-0016 N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464 N7764MEifert Steven W · Clarksville, TNBuilt 1974 · S/N 20-0017 N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465 N7765MProgressive Medical Applications Corp · Allentown, PABuilt 1974 · S/N 20-0018 N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466 N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467 N7768MHoyle Charles D Jr · Eureka, CABuilt 1974 · S/N 22-0024 N7769MCorso Nicholas J · Stuart, FLBuilt 1974 · S/N 22-0025 N776ACMonska Stephen M · Florence, MABuilt 1997 · S/N 1233-97 N776DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N R18200556 N776NHHylton Nathaniel Dean · Pleasant Plain, OHBuilt 1965 · S/N 567 N7770GMyers Keith R Trustee · Fond Du Lac, WIBuilt 1970 · S/N 17259470 N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471 N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472 N7772MDyrstad William M · Hampshire, ILBuilt 1974 · S/N 22-0028 N7774CTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1973 · S/N 0093 N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474 N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475 N7775MDennis Bruce · Rapid City, MIBuilt 1974 · S/N 20-0021 N7775SWildes Thomas · Chippewa Falls, WIBuilt 1976 · S/N 227-76 N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476 N7776MPinckney Robert L · Elgin, SCFirst renewal noticeBuilt 1974 · S/N 21-0032 N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334 N7778Carpenter Darrell W · Midland City, ALBuilt 1973 · S/N 177RG0349 N7778BPeters Ben C · Leavenworth, WAS/N 2750 N7779JLehrkamp Mike C · Caputa, SDBuilt 1966 · S/N 536 N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695 N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156 N777DLShamrock Kelly Energy Inc · Blanco, TXBuilt 1979 · S/N P21000373 N777DUSc Infinities LLC · Dover, DEBuilt 1971 · S/N 17259854 N777DWLawless Aviation LLC · Fishers, INS/N 327-77 N777ECMitchener Michael Shane · Marlborough, MABuilt 1996 · S/N 24-3399 N777FYQualitair LLC Trustee · ChelstadtBuilt 1979 · S/N P21000276 N777HJBallantyne Benjamin J · South China, MEBuilt 1972 · S/N 841-72 N777LH7 Moon LLC · Albuquerque, NMS/N 3151 N777LTYates Deborah L · Pioneer, CABuilt 1978 · S/N 24-0691 N777MRRutherford Michael A · Medina, OHBuilt 1974 · S/N 1068-75 N777UMMahlik Michael A · Casco, WIS/N 17275405 N777VJTucker Billy J · Arley, ALBuilt 1979 · S/N R18200870 N777YTKeyt LLC · Missoula, MTBuilt 1981 · S/N 18268029

Back to AD 80-25-07 R1