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.

N7666GHudson Daryl J · Redwood Valley, CABuilt 1970 · S/N 17259366 N7667GBrooks Alan G · Kernersville, NCBuilt 1970 · S/N 17259367 N7668SJacobson Luke W · Reno, NVBuilt 1976 · S/N 589-76 N7669GWingsleasing LLC · Wichita, KSBuilt 1970 · S/N 17259369 N766CPCity Of Cleveland · Cleveland, OHBuilt 1975 · S/N 172-66326 N766TWBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N 17274134 N7670GPremier Aviation LLC · Philadelphia, MSBuilt 1970 · S/N 17259370 N7670SShortridge Randall R · Mesa, AZBuilt 1976 · S/N 218-76 N7671SKlos Aero LLC · Plevna, MTS/N 254-76 N7672SLouisville Soaring Club Inc · Lexington, KYBuilt 1976 · S/N 222-76 N7673GSchaack Lawrence A · Woods Cross, UTBuilt 1970 · S/N 17259373 N7674SMurtagh Johhny T · Lexington, MSBuilt 1976 · S/N 932-76 N7675SKemp Gilbert A · Waterville, NYBuilt 1976 · S/N 1170-76 N7676GPalmer Michael C · Emmett, IDBuilt 1970 · S/N 17259376 N7677VDoxtator Christopher P · Covington, INBuilt 1982 · S/N 24-1328 N7678GTanner Michael J · Hooksett, NHS/N 17259378 N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379 N767ACWooldridge Kent L · Albany, ORBuilt 2000 · S/N 410-2000 N767AWTooth & Go Flyers LLC · Farmington Hills, MIBuilt 1964 · S/N 413 N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607 N767CGMindy Limited LLC · Muscatine, IAS/N 17269309 N767DPBeardsley William A · Tracy, CABuilt 1963 · S/N 188 N767GGabbard Michael · Jupiter, FLBuilt 1979 · S/N R18200900 N767PAviation Investments Inc · Virginia Beach, VAS/N 262-73 N767RAmerican Champion Aircraft Corp · Rochester, WIS/N 648-2027 N767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N P21000161 N767SECoyote Aviation LLC · Carefree, AZBuilt 2004 · S/N 1374-2004 N767WDLibby William J · Hooksett, NHBuilt 1978 · S/N R18200862 N7680GGulyash Michael J · Ukiah, CAS/N 17259380 N7680SHallsten Stephen B · Fairbanks, AKBuilt 1976 · S/N 221-76 N7681GCompass Aviation Inc · Shelby, NCBuilt 1970 · S/N 17259381 N7681SCawley Jeffrey W · Buckley, WABuilt 1976 · S/N 907-76 N7683GBalgoyen James T · Charlotte, MIBuilt 1970 · S/N 17259383 N7683SSzabolscky Stephen L · Remington, VABuilt 1976 · S/N 257-76 N7684SStrehle Scott · Lewiston, IDS/N 934-76 N7685MLazy Double Air LLC · Bloomer, WIBuilt 1980 · S/N R18201583 N7685NFranklin Construction Inc · Chico, CAS/N 21063247 N7685SHull Kevin G · Sadler, TXBuilt 1976 · S/N 58276 N7687SLynn Robert W · Independence, WVBuilt 1976 · S/N 936-76 N7688SJohnson Brian G · Goodridge, MNBuilt 1976 · S/N 937-76 N7689GMerrihew Jerry R · Ashby, NEBuilt 1970 · S/N 17259389 N768ACBowe Joseph E · Ocklawaha, FLBuilt 1999 · S/N 1268-99 N768CStieren George L · Kerrville, TXBuilt 2010 · S/N 532-2010 N768CCDymek Dana · Glencoe, ILBuilt 1976 · S/N 221352 N768TPjd Holdings LLC · Grand Blanc, MIBuilt 2025 · S/N 1488-2025 N7690SCollum Aviation LLC · Milton, FLBuilt 1976 · S/N 224-76 N7693GA J L M Partners LLC · Hershey, NEBuilt 1970 · S/N 17259393 N7694SBaker Bruce A · Chandler, AZBuilt 1976 · S/N 260-76 N7694VMarkowski John J · Guilford, CTBuilt 1976 · S/N 177RG0904 N7695GPfeifer Kenneth J · Bridger, MTS/N 17259395

Back to AD 80-25-07 R1