OpenAirDocs.org
AD 80-25-07 R1

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
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.

N201DMN201dm Corp Trustee · Wilmington, DEBuilt 1976 · S/N 24-0060N201DNSale Reported · Hudson, FLSale reported, pending cancellationBuilt 1977 · S/N 24-0163N201DPMahoney Dustin G · Lakewood, COBuilt 1976 · S/N 24-0065N201DQBrande Lewis · Alta Loma, CABuilt 1977 · S/N 24-0091N201DRKpjp LLC · Spicewood, TXBuilt 1976 · S/N 24-0028N201DSM 20 Flyer LLC · Hector, MNBuilt 1976 · S/N 24-0015N201DUSiniscalchi Joseph W · Heath, TXBuilt 1977 · S/N 24-0119N201DVDevine Robert L · Condon, ORBuilt 1977 · S/N 24-0088N201DXDe Young Miles J · Florence, COBuilt 1976 · S/N 240027N201DYDrenner Scott · Mount Pleasant, WIBuilt 1965 · S/N 857N201EMccormick Richard · Morgan Hill, CABuilt 1979 · S/N 24-0912N201EBIsrael Raj · Saint Joseph, MIFirst renewal noticeBuilt 1977 · S/N 24-0112N201ECHaselden William C · Hastings, MIBuilt 1978 · S/N 24-0635N201EDRhodes Emmer F · Newton, IABuilt 1977 · S/N 24-0097N201EENational University Services Inc · Salem, VABuilt 1976 · S/N 24-0076N201EFDace Ronald K · New Berlin, ILBuilt 1977 · S/N 24-0130N201EGGomez Roman Jr · San Antonio, TXBuilt 1978 · S/N 24-0479N201EHLindsay Construction LLC · Fernandina Beach, FLS/N 24-0144N201EJVann Dudley C · Greenville, NCBuilt 1977 · S/N 24-0159N201EMShore Dogs LLC · West Hartford, CTBuilt 1977 · S/N 24-0147N201EPStinchcomb Jason B · Aledo, TXBuilt 1976 · S/N 24-0074N201EQM20j Aerospace LLC · League City, TXBuilt 1977 · S/N 24-0162N201ERProject Freight LLC · Brunswick, GABuilt 1977 · S/N 24-0141N201ESLaflin Steven · Idaho Falls, IDBuilt 1976 · S/N 24-0067N201ETThomas Daniel C · Shady Shores, TXBuilt 1976 · S/N 24-0037N201EWSondgeroth John · East Marion, NYBuilt 1978 · S/N 24-0446N201FTuley Robert T · Colleyville, TXBuilt 1978 · S/N 24-0687N201FAFooks Air LLC · Seaford, DEBuilt 1976 · S/N 24-0017N201FBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 24-0105N201FCNeely Michael D · Huson, MTBuilt 1976 · S/N 24-0064N201FGReed Philip B · Martinsville, INFirst renewal noticeBuilt 1977 · S/N 24-0179N201FJJensen Keith E · Pocatello, IDBuilt 1977 · S/N 24-0185N201FLFairservice John G Jr · Mechanicsville, VAFirst renewal noticeBuilt 1977 · S/N 24-0154N201FNRobello Michael T · Belton, TXBuilt 1977 · S/N 24-0238N201FPShank Carl V · Beaver Falls, PABuilt 1977 · S/N 24-0189N201FQWalker Lisa A · Capistrano Beach, CABuilt 1977 · S/N 24-0194N201FTCurran Stephen S · Coppell, TXBuilt 1977 · S/N 24-0101N201FVWest Lake Houston Aviation LLC · Houston, TXBuilt 1977 · S/N 24-0213N201FXMr Dent Inc · Manheim, PABuilt 1977 · S/N 24-0206N201FYJauregui Alberto T · Key Biscayne, FLBuilt 1977 · S/N 24-0210N201GCBosse Don R · Bellville, TXBuilt 1977 · S/N 24-0169N201GDEide Glenn Mitchell · Wayzata, MNBuilt 1977 · S/N 24-0216N201GESanders Michael W · Austell, GABuilt 1977 · S/N 24-0103N201GHPayne Jason C · Thomaston, CTBuilt 1976 · S/N 24-0075N201GJAllmarc LLC · Molalla, ORBuilt 1977 · S/N 24-0134N201GNThomas J Smith · Baton Rouge, LAS/N 24-0219N201GPSale Reported · Sheridan, WYSale reportedBuilt 1976 · S/N 24-0054N201GQHolm Chris C · Myrtle Point, ORFirst renewal noticeBuilt 1977 · S/N 24-0221N201GRBischoff Roy H III · Belleville, ILS/N 24-0222N201GTHave Blue Aviation LLC · Philipsburg, MTBuilt 1978 · S/N 24-0575
Back to AD 80-25-07 R1