Registered aircraft · 25,368

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.

N9607YIsn Aviation LLC · Loup City, NEBuilt 1981 · S/N 21064559 N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261 N9608MWaryas Robert A · Long Island, VAFirst renewal noticeBuilt 1967 · S/N 670107 N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693 N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1985 · S/N 15286006 N96096Jwa Flight School LLC · Bolingbrook, ILBuilt 1985 · S/N 15286007 N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694 N9609URykala Martha E · Hayward, CABuilt 1980 · S/N 24-1067 N9609VFly Fly Fly LLC · Dover, DEBuilt 1971 · S/N 21-0015 N960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386 N960GSStevens Chad M · Huntsville, ALBuilt 1964 · S/N 2858 N960RMCag International Inc DBA · Longmont, COBuilt 2000 · S/N 852-99 N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020 N96105Demon Air LLC · Palm City, FLS/N 17276023 N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695 N9610SLake A Randy · San Diego, CABuilt 1966 · S/N 265 N9611MElectron Neutrino Inc · Lewes, DEBuilt 1966 · S/N 670188 N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263 N9612VLe Roux Rocco · Carlsbad, CABuilt 1971 · S/N 21-0018 N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264 N9613MLeland Erik J · Beaverton, ORS/N 670190 N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265 N9614KPassmore Stephen B · Lacrosse, WABuilt 1983 · S/N T18803962T N9614MSmith Michael O · Conroe, TXBuilt 1966 · S/N 670191 N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699 N9614SFlatonia Veterinary Clinic Inc · Flatonia, TXBuilt 1966 · S/N 46 N9615MMorgan Mark · Durango, COBuilt 1966 · S/N 670192 N9615TEtzel Gregory J · Lafayette, INBuilt 1978 · S/N 38-78A0145 N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590 N9616MBohn Aaron L · Valdosta, GAS/N 670193 N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701 N9616VFlorio Michael J Jr Owner · Northampton, MABuilt 1971 · S/N 21-0022 N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543 N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267 N9617MSlusser Dennis G · Biggs, CAFirst renewal noticeBuilt 1966 · S/N 670194 N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702 N9617SAnderson David R · Hastings, MNBuilt 1966 · S/N 366 N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034 N9618MPatton Jeremy M · Dolores, COBuilt 1966 · S/N 670195 N9618SBradley Christopher · Juneau, AKBuilt 1965 · S/N 385 N9618VBishop Kenneth G · Chester, MDBuilt 1971 · S/N 22-0009 N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039 N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924 N9619SCulp Barney L Jr · Emerald Isle, NCBuilt 1965 · S/N 13 N961JKRegistration Pending · Menasha, WIRegistration pendingBuilt 1976 · S/N 22-1400 N9620GMehling Robert C · Hardin, MTS/N 18801564 N9620VLetendre Norman W · Port Saint Lucie, FLBuilt 1971 · S/N 22-0011 N9621MSkys Mooney LLC · Missoula, MTBuilt 1966 · S/N 670198 N9621VHathor Aviation LLC · Johnstown, COBuilt 1974 · S/N 17264401 N9622HSanders Flight Training Center LLC · Jasper, ALBuilt 1975 · S/N 17266272

Back to AD 80-25-07 R1