Registered aircraft · 25,369

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.

N65772Sky Adventure LLC · Bartlett, TNBuilt 1982 · S/N 17275875 N65773Ial Corp · Lewes, DEBuilt 1982 · S/N 17275876 N65775Ristrim Eric · Henderson, NVBuilt 1982 · S/N 17275878 N65776Meridian Aviation Holding Company · Teterboro, NJBuilt 1982 · S/N 17275879 N6577HRegistered aircraftBuilt 1975 · S/N 17265496 N6577QForce Gary · Granbury, TXBuilt 1981 · S/N 15285275 N6577RAir Echo Alpha 51 LLC · Erie, COBuilt 1979 · S/N 172RG0203 N6577UKoehler Richard E · Port Orange, FLBuilt 1962 · S/N 2359 N65784Ohio State University · Columbus, OHBuilt 1982 · S/N 17275884 N65789Burket George C · North Hollywood, CABuilt 1982 · S/N 17275888 N6578UJbl Aeronovia LLC · Kent, WAS/N 2360 N65798Samons David M · Phoenix, AZBuilt 1982 · S/N 17275894 N6579URegistered aircraftBuilt 1962 · S/N 2361 N657FTNeal Randy W · Johns Creek, GABuilt 1992 · S/N 24-3268 N657MVLeyden Aviation LLC · Dover, DEBuilt 2021 · S/N 616-2021 N657SCKruse Shannon E · Republic, MOBuilt 1973 · S/N 177RG0301 N657SRRm & Lp Ltd · Azalea, ORBuilt 1968 · S/N 17701019 N6580LHigh Wing Air Services LLC · Merritt Island, FLBuilt 1980 · S/N 15284446 N65813Northwest Wings LLC · Hillsboro, ORBuilt 1983 · S/N 17275896 N65815Montgomery David A · Mancelona, MIS/N 17275897 N6581VSimmons Claude E · Ocracoke, NCBuilt 1980 · S/N 172RG0777 N65821Goodley Scott Val · Denton, TXBuilt 1982 · S/N 17275899 N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191 N6583UTexas Sabal Inc · San Antonio, TXS/N 2365 N65842Holladay Aviation LLC · Jacksonville, FLBuilt 1983 · S/N 17275906 N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112 N6584UOreilly John · Lady Lake, FLBuilt 1962 · S/N 2366 N6585UFischer Bryan · Larned, KSS/N 2367 N65866Planenutz LLC · Deland, FLBuilt 1983 · S/N 17275908 N6586HOracle Aviation LLC · Omaha, NEBuilt 1975 · S/N 17265498 N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800 N65872Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275909 N6587EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272040 N6588HSwanson David L · Rolling Meadows, ILBuilt 1975 · S/N 17265500 N65892Amelia Airways LLC · Boynton Beach, FLFirst renewal noticeBuilt 1983 · S/N 17275914 N658LMLge Flying Club Inc · Marietta, GABuilt 1973 · S/N 17261599 N658NVJp Aero Holdings Inc · Carson City, NVBuilt 1981 · S/N 17275439 N658SRJung Sue Elaine · Lawton, OKBuilt 1968 · S/N 17700976 N658TAmerican Champion Aircraft Corp · Rochester, WIS/N 1237-2027 N65909Oldwater Trailers Inc · Wilmington, DEBuilt 1983 · S/N 17275920 N6590USanchez John D · Columbiaville, MIBuilt 1962 · S/N 2372 N6591EWay Robert Louis · Morristown, AZBuilt 1978 · S/N 17272041 N6591NRickey James R · Hanford, CAFirst renewal noticeBuilt 1978 · S/N 21063114 N65923Noste Erik · Mount Vernon, WABuilt 1983 · S/N 17275923 N6592QCd Aircraft LLC · Signal Hill, CABuilt 1981 · S/N 15285277 N6592UEriksson Trent A · Waterford, MIBuilt 1962 · S/N 2374 N6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N P21000801 N6595G95 Golf Inc · Greenwood, INBuilt 1980 · S/N 17273609 N65965Legends Air Center LLC · Bentonville, ARBuilt 1978 · S/N 15281658 N6596DMcdonald Kevin K · Anchorage, AKBuilt 1979 · S/N 17272885

Back to AD 80-25-07 R1