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.

N9696LAny Border LLC · Yankton, SDBuilt 1986 · S/N 17276599 N9697VWestern Edge Aviation LLC · Dickinson, NDBuilt 1974 · S/N 17264476 N9698HEagle Simulator LLC · Lake Oswego, ORBuilt 1975 · S/N 17266322 N9698MCiota Shane · Tucson, AZBuilt 1967 · S/N 670245 N9698SLindgren Darrell A · Lake Nebagamon, WIBuilt 1966 · S/N 47 N9698VVermont Flight Academy Inc · South Burlington, VTBuilt 1974 · S/N 17264477 N9699SBaumann Matt · Chewelah, WABuilt 1966 · S/N 430 N9699VPiercy Danille Marie · North Bay Village, FLBuilt 1974 · S/N 17264478 N969AAFlight Path LLC · Egg Harbor City, NJBuilt 2021 · S/N 1191-2021 N969DGDelta Sierra Avia Inc · West New York, NJBuilt 1967 · S/N 680117 N969FPLarson Danny O · Palmer, AKS/N 1225-96 N969JHJls Aviation LLC DBA · Fredericksburg, VABuilt 1979 · S/N 17273547 N969RRDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275850 N969RSShawn Richard N · Bradford, RIBuilt 1979 · S/N 24-0818 N969TTSmoketown Flight Center LLC · Smoketown, PABuilt 1973 · S/N 17261635 N969TXMowata Farms LLC · Mamou, LAS/N P21000145 N96AWPlanenutz LLC · Deland, FLBuilt 1966 · S/N 3289 N96CBNine Six Charlie Bravo LLC · Aspen, COBuilt 1994 · S/N 24-3346 N96ERGunn Sean M · Colorado Springs, COBuilt 1993 · S/N 24-3308 N96FRWoodward-Davis LLC · Nacogdoches, TXBuilt 1980 · S/N 17274184 N96KSMower Douglas D · Cedar Ridge, CAS/N 24-3361 N96RHAtlanta Aircraft Group LLC · Atlanta, GABuilt 1981 · S/N P21000720 N96WPVanneman William M · Ludlow, VTBuilt 1978 · S/N R182-00216 N96WWDragging Tails LLC · Madison, MSBuilt 2001 · S/N 888-2001 N9700HBrutko Barry J · Lebanon, PABuilt 1975 · S/N 17266323 N9700JCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1981 · S/N T18803840T N9700VStencel Lawrence E · Palm Coast, FLBuilt 1974 · S/N 17264479 N97019Mccreery Aviation Co Inc · Mcallen, TXBuilt 1984 · S/N 17276146 N9701MInternational Air Services Inc Trustee · Carson City, NVS/N 670261 N9702LFlying Dreams One LLC · Louisville, KYBuilt 1986 · S/N 17276600 N9702MPippin Alan D · Prattville, ALBuilt 1967 · S/N 670262 N9703JSchmitt Rudy · Brookshire, TXBuilt 1981 · S/N 18803841T N9703MBertucci David · Sunnyvale, CABuilt 1967 · S/N 670263 N97045Smith Brandon J · Casselton, NDBuilt 1984 · S/N 17276148 N97055Skaya Aircraft LLC · Kalispell, MTBuilt 1984 · S/N 17276149 N9706MDance David C · Idaho Falls, IDBuilt 1967 · S/N 670116 N9706QTzafrir Sheffer · Seattle, WABuilt 1975 · S/N 17265784 N9706VDagnon Paul A · Apple Valley, MNBuilt 1974 · S/N 17264482 N97075Sopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1984 · S/N 17276152 N9707JTop Hand Inc · Laurel, MTBuilt 1981 · S/N T18803842T N9707MCombs Charles D · Buffalo, MOBuilt 1967 · S/N 670267 N9709BPeterson Air LLC · Chisago City, MNBuilt 1981 · S/N 172RG0982 N9709MAndersen Michael S · Bensenville, ILBuilt 1967 · S/N 670269 N970PGJoyful Flight LLC · Madison, WIBuilt 2000 · S/N 452-2000 N970SETraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15283609 N970YGCbk LLC · Eagle, COBuilt 1979 · S/N P21000219 N9710BWellnitz Patrick · Whitewater, WIS/N 172RG0983 N97116N97116 LLC · Hector, MNS/N 17276155 N9711MKats Daniel L Jr · Labelle, FLBuilt 1967 · S/N 670271 N9712NKeller Gerald C · Kokomo, INS/N 156

Back to AD 80-25-07 R1