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.

N46748Roscioli Lamberto · Lighthouse Point, FLBuilt 1978 · S/N 15283098 N4674SDirect Oscar LLC · Jamestown, NYS/N R18201376 N4674UKlein David · Sebastopol, CABuilt 1983 · S/N 21064802 N46762Kay Bennie L · Brigham City, UTBuilt 1978 · S/N 15283102 N4678TRothberg Diane Lee · Gainesville, GABuilt 1981 · S/N R18201730 N4679GFlightime Inc · Elkhart, INS/N 17273305 N4679HAdams Kris · Griffin, GABuilt 1979 · S/N 24-0808 N4679YExtreme Air LLC · Cottage Grove, WIBuilt 1980 · S/N 21063983 N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879 N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475 N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649 N46803Ken Graham Phd Inc · Sioux Falls, SDBuilt 1979 · S/N 15283108 N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814 N4681SRezek William E · Centennial, COBuilt 1979 · S/N R18201377 N46826Registration Pending · Tampa, FLRegistration pendingBuilt 1979 · S/N 15283114 N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330 N4683GDeichert Ryan L · Bismarck, NDS/N 17273309 N4683STorley Christopher · Flower Mound, TXBuilt 1979 · S/N R18201378 N4684TMk Aviation LLC · Charlotte, NCS/N R18201733 N46854Phillips Joe Christopher · Grand Prairie, TXBuilt 1979 · S/N 15283121 N4685TMalagrifa Richard · Swampscott, MABuilt 1981 · S/N R18201734 N4686LGlenn Roger H · Pacifica, CABuilt 1980 · S/N 15284216 N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365 N4687SP & V Howard Enterprises LLC · Angleton, TXBuilt 1979 · S/N R18201380 N4687VSharp Cutlass LLC · Iowa City, IABuilt 1980 · S/N 172RG0366 N46889Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283133 N4688SDiaz Eliu · Charlotte, NCBuilt 1979 · S/N R18201381 N4689SHoffman Joseph A · El Dorado Hills, CABuilt 1979 · S/N R18200591 N468DRBrantley James · Estero, FLBuilt 2016 · S/N 579-2016 N468MSSturdivant Mike P Jr · Glendora, MSBuilt 1980 · S/N 21063969 N468RGMyers Michael J · Vinton, IABuilt 1979 · S/N R18201057 N468SLd Funding LLC · Piscataway, NJBuilt 1994 · S/N 243324 N468WPerson Matt · Denton, NEBuilt 1978 · S/N 24-0404 N46907Bagamaspad Alan Antonio · Los Angeles, CABuilt 1979 · S/N 15283137 N4690HCozzolino Richard A · Hamden, CTBuilt 1979 · S/N 24-0809 N4691GLr Properties LLC · Goodyear, AZS/N 17273317 N4692GJz Air LLC · Brooklyn, NYS/N 17273318 N4692QZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1973 · S/N 17261745 N4693EJayo Construction Inc · Boise, IDS/N 18268261 N4693JThibodeaux Gerald J · Duson, LABuilt 1979 · S/N 17273663 N4693QSievert David M · Santa Cruz, CABuilt 1973 · S/N 17261746 N4694GRegistered aircraftBuilt 1979 · S/N 17273320 N4694SNyhus David L · Bismarck, NDBuilt 1979 · S/N R18201384 N4694YKempton Chevrolet Buick Ltd · Safford, AZBuilt 1980 · S/N 21063988 N46953Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 15283149 N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816 N46964Simsbury Aviation Services LLC · Simsbury, CTBuilt 1979 · S/N 15283152 N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073 N4696THess Aero Corp Inc · Huntsville, ALBuilt 1981 · S/N R18201737 N4697GVeety Roy D · Dalton, PAS/N 17273323

Back to AD 80-25-07 R1