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.

N369NEPeter Travis E · Evansville, WYBuilt 1979 · S/N 172RG0233 N369PPPositive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263099 N369RAShaffer Patricia G · Texarkana, TXBuilt 1971 · S/N 17259719 N369RJD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17273068 N369RPRegistered aircraftBuilt 1988 · S/N 24-1682 N369SPXin Han Aviation LLC · Helena, MTS/N 17262809 N36AFLewis Richard M Jr · Deltaville, VABuilt 1977 · S/N R18200104 N36CCPittsburgh Marine Technologies Inc · Eighty Four, PAS/N 15283484 N36CEHawkes Delray · Sequim, WABuilt 1982 · S/N 24-1321 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N36GRRiethof George N · Nantucket, MABuilt 1978 · S/N 17272026 N36HNBush Thomas D Jr · Cypress, TXBuilt 1965 · S/N 754 N36JCSafety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 17261759 N36JWBarr Air Patrol LLC · Mesquite, TXBuilt 1975 · S/N 17265589 N36RSSalerno Michael · Pueblo, COBuilt 1999 · S/N 1280-99 N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691 N36ZQNorthern Flights LLC · Calumet, MIBuilt 1975 · S/N 17265019 N3702FBuzjob Aviation LLC · Los Angeles, CABuilt 1976 · S/N 0739 N3703FPresby Aire LLC · Berlin, NHBuilt 1976 · S/N 0738 N3703HTsyupka Andriy · Hinsdale, ILBuilt 1979 · S/N 24-0904 N3705FMonteith Andrew W · Lebanon, PABuilt 1977 · S/N 0750 N3705HGeyer Donovan · Palo Cedro, CABuilt 1979 · S/N 24-0905 N3706HDurand Ryan A · Hermantown, MNBuilt 1979 · S/N 24-0906 N3706NJsn Aviation LLC · Huntersville, NCBuilt 1967 · S/N 680044 N3709NShow Me The Mooney LLC · Hartford, KYBuilt 1967 · S/N 680045 N370ACNuza Philip A · Sidney, MEBuilt 2000 · S/N 433-99 N370SNesbit Stephen W · Hemphill, TXBuilt 1968 · S/N 17700692 N370XPMckerney Charles A · Anchorage, AKBuilt 1976 · S/N 17267622 N3712HSpencer James W · Valley Lee, MDBuilt 1979 · S/N 24-0909 N3714NFerguson Michael D · Mendon, MIBuilt 1967 · S/N 680046 N3715NHeiderscheidt Cory L · Sleepy Eye, MNBuilt 1967 · S/N 680047 N3716HSky Deals LLC · Kearney, NEBuilt 1979 · S/N 24-0911 N371ACBloom Thomas C · Henderson, NVBuilt 2002 · S/N 435-2002 N371DMCity Of Bakersfield California · Bakersfield, CABuilt 2000 · S/N 416-2000 N371LSatellite Flying Club Inc · East Patchogue, NYBuilt 1970 · S/N 17701488 N371PFInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 0743 N3726CRogers Glenn A Jr · Sedona, AZBuilt 1978 · S/N R18200321 N3726NVilvens Justin T · Granville, OHBuilt 1968 · S/N 680051 N372FTTownsend Frederick H · Ortonville, MIBuilt 1972 · S/N 832-72 N372GGIal Corp · Lewes, DEBuilt 1981 · S/N 17274926 N372SAJoe Wagner IV Construction LLC · Zebulon, NCBuilt 1979 · S/N 17272854 N3731FCarder Wiley C · Cameron Park, CABuilt 1976 · S/N 0746 N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308 N3742FBenson Edward A · San Antonio, TXBuilt 1977 · S/N 0755 N3742HLocurto Anthony C · Alexandria, VABuilt 1979 · S/N 24-0918 N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052 N3747BAviation Specialists Inc · Gonzales, LABuilt 1979 · S/N R18201305 N374SMN374sm LLC · Orlando, FLBuilt 1984 · S/N 24-1464 N3751FAdrion Advisors Inc · Winter Haven, FLBuilt 1977 · S/N 0756 N3751HSoftcomm Aviation Inc · Irvine, CABuilt 1979 · S/N 24-0923

Back to AD 80-25-07 R1