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.

N91751Aviators Cooperative LLC · Colorado Springs, COBuilt 1973 · S/N 17261509 N9176HSky Walker Flight School LLC · Adrian, MIBuilt 1975 · S/N 17265993 N9177HLind Enterprises LLC · Manistee, MIBuilt 1976 · S/N 17265994 N9178CKelly Randall Shawn · Rocklin, CABuilt 1978 · S/N R18200437 N9178LClarke Paul W · Cape Girardeau, MOBuilt 1972 · S/N 5-72 N9178QMartinez Manuel G · Downers Grove, ILBuilt 1976 · S/N 20-1197 N9178VWingman Aviation Partners LLC · Wentzville, MOBuilt 1969 · S/N 690017 N91793Oexmann James Bennett · Lexington, KYS/N 17261514 N9179HMeteiver Lawrence J · Elkhart, INBuilt 1975 · S/N 17265995 N9179VVinter Mooney LLC · Philadelphia, PAS/N 690035 N917AXGast Matthew Adam · Weston, WIBuilt 2026 · S/N 1233-2026 N917FAAlpha Aircraft International LLC · Lake Worth, FLBuilt 1980 · S/N 17274062 N917GJHawdon Neil John · Federal Way, WAS/N 17702703 N917GKAmdel Holding LLC · Houston, TXBuilt 1978 · S/N 17271567 N917WETaylor William H II · Albuquerque, NMBuilt 1968 · S/N 17256920 N91813Fallbrook Fly Girl LLC · Lakeside, ORBuilt 1973 · S/N 17261515 N91823Perra John James Trustee · Gardnerville, NVBuilt 1973 · S/N 17261516 N9182AAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1982 · S/N 38-82A0102 N9182HMouton Charles · Gladewater, TXBuilt 1975 · S/N 17265997 N9183VBerrong Jimmy L · Dahlonega, GABuilt 1969 · S/N 690039 N9184LKindred Champ LLC · Hickson, NDBuilt 1971 · S/N 327-72 N9184VCloud Distributing LLC · Austin, TXBuilt 1969 · S/N 690036 N91854Sjostedt Brad D · Cordova, AKS/N 357-72 N9185HFlyit LLC · Washougal, WABuilt 1975 · S/N 17265999 N9185LKnighten Ammon J · Gakona, AKBuilt 1971 · S/N 324-72 N91862Aire Services LLC · Barrigada, GUBuilt 1973 · S/N 17261519 N9186LAshby Darrell T · Elko, MNBuilt 1971 · S/N 231-72 N9187CKd3262 LLC · Downers Grove, ILBuilt 1978 · S/N R18200439 N9187LGardner James Jr · El Campo, TXBuilt 1971 · S/N 328-72 N9187RMih LLC · Birmingham, ALBuilt 1978 · S/N R18200666 N9188GAircraft Management Services Inc · Milton, FLBuilt 1979 · S/N 17273625 N9188LSodowsky Jim L · Ponca City, OKBuilt 1971 · S/N 814-72 N9188VValiair Limited Co Trustee · Casper, WYBuilt 1969 · S/N 690049 N9189HPendergrass Aviation Inc · Demopolis, ALBuilt 1975 · S/N 17266002 N9189VEl Capitan LLC · Thornton, COBuilt 1969 · S/N 690040 N918FAWestways Aviation LLC · El Cajon, CABuilt 1981 · S/N 17274981 N918PMMathews Roy · Bay Shore, NYBuilt 1980 · S/N 172RG0602 N918THLayton James L · Carrollton, GABuilt 1992 · S/N 24-3258 N918UGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285441 N918VAVolatus Aerospace US Corp · Syracuse, NYS/N 17274912 N918VPVanderpool Robert W · Red Devil, AKS/N 17266379 N918VTChannel Islands Aviation Inc · Camarillo, CAS/N 17275241 N91919Anderson Aerial Spraying Service Inc · Canby, MNS/N 18802053T N9191LMeyer Gordon L · Knoxville, TNBuilt 1971 · S/N 815-72 N91925Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17261524 N9193GMach One Velocity LLC · Macomb Twp, MIBuilt 1979 · S/N 17273626 N9193HPrairie Flyers Flying Club · Eudora, KSBuilt 1975 · S/N 17266006 N9193LAdriatic Holdings LLC · Cheyenne, WYBuilt 1971 · S/N 817-72 N9194LRussell Keith M · Ivoryton, CTBuilt 1971 · S/N 818-72 N9194VAlva Aviation LLC · Nacogdoches, TXBuilt 1969 · S/N 690040

Back to AD 80-25-07 R1