Registered aircraft · 25,370

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.

N4737LSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15284228 N4737SMaverick Consulting LLC · Prior Lake, MNBuilt 1979 · S/N R18201406 N4738GCmk Aerial Inc · Sutton, NES/N 17273335 N4738HBravo Tango Properties LLC · Gahanna, OHBuilt 1979 · S/N 24-0831 N4739DMuddy Creek Aviation LLC · Dayton, VAS/N 17272346 N4739HDwyer James F · Denver, COBuilt 1979 · S/N 24-0832 N4739JVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 17273672 N473KPDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1982 · S/N 172RG1132 N4740RCall Tracy J · Carmel Valley, CABuilt 1978 · S/N R18200608 N47417Kirst Forest Mitchell · Fairbanks, AKBuilt 1979 · S/N 15283224 N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272 N4741SOkkb2 Inc · Vancouver, WABuilt 1979 · S/N R18201408 N47422Sfdb Aviation Inc · Pompano Beach, FLBuilt 1979 · S/N 15283225 N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810 N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608 N4743SDimitri Bevc · Pleasanton, CABuilt 1979 · S/N R18201409 N4744CDesert Aviation LLC · Kingman, AZBuilt 1979 · S/N 21063609 N4744GJackson Flight Center LLC · Moses Lake, WABuilt 1979 · S/N 17273336 N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275 N4745PNorris Phillip A · Stanton, CABuilt 1980 · S/N 15284808 N4746HEdenburn Douglas Lindley · Concord, NCBuilt 1979 · S/N 24-0833 N4746RZurawski Joseph · Ocala, FLBuilt 1979 · S/N 172RG0022 N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611 N4747KFloyd Don B · Snohomish, WAFirst renewal noticeBuilt 1979 · S/N P21000278 N4748JYecny Enterprises Inc DBA · San Luis Obispo, CAFirst renewal noticeBuilt 1979 · S/N 17273673 N474AARegistered aircraftBuilt 1974 · S/N 17263357 N474ACOverland Leasing Inc · La Porte, TXBuilt 2000 · S/N 854-99 N474AWCenturion Aviation LLC · Ada, MIBuilt 1981 · S/N P21000652 N474CTThomas Wayne H · Dover, DEBuilt 1981 · S/N 1002 N474DCPopescu Marian · Pensacola, FLS/N 24-1623 N474HAHutch Aviation Inc · Zavalla, TXS/N 17262845 N474HBGreene William T · Dresser, WIBuilt 2017 · S/N 590-2018 N474JSAmerican Champion Aircraft Corp · Rochester, WIS/N 1494-2026 N474KPFaith Norman E Jr · El Dorado, ARBuilt 1981 · S/N 172RG0825 N474TBDr Daniel Brancheau Pllc · Fenton, MIBuilt 1980 · S/N 172RG0238 N474WBPhillips Kenneth R · Brackettville, TXBuilt 1974 · S/N 21-74 N4751GJeff Air Pilot Services LLC · Shelbyville, INS/N 17273337 N4751QHofer Bruce L · Freeman, SDBuilt 1976 · S/N 18802508 N4751TAerial Perspective LLC · Mount Holly, NJBuilt 1981 · S/N R18201751 N4752BCelestial Associates LLC · Jonesboro, GAS/N 15283616 N4752KAraiza Fernando A · Tucson, AZBuilt 1979 · S/N P21000283 N4752RCondors Flight LLC · Orlando, FLS/N 172RG0023 N4752SRion Aviation Corporation · Wilmington, DEBuilt 1979 · S/N R18201414 N4753UTurchan Robert H · Scottsdale, AZBuilt 1983 · S/N 21064811 N4754SNichols William R Jr · Austin, TXBuilt 1979 · S/N R18201416 N4755KPhilmar LLC · Oshkosh, WIBuilt 1979 · S/N P21000286 N4755PJet & Rotor Aviation LLC · Sacramento, CABuilt 1980 · S/N 15284810 N47563Mike Mooney Construction LLC · Wilmington, DEBuilt 1979 · S/N 15283235 N47567Jordan Clifford A · Woodbridge, VABuilt 1979 · S/N 15283236 N4756CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 21063613

Back to AD 80-25-07 R1