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.

N47189Xclusive Level Aircraft World LLC · Kissimmee, FLS/N 15283183 N4718AQuinby Gary D Trustee · Ardmore, OKBuilt 1979 · S/N A1520880 N47193Cloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283185 N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076 N4719HGanim Rose · Haydenville, MABuilt 1979 · S/N 24-0821 N4719TOchoa Ricardo · Douglas, AZS/N R18201742 N471ACWard Allen M · Andalusia, ALBuilt 1998 · S/N 410-98 N471GMHarland Willard G · Tuscumbia, ALBuilt 1979 · S/N R18201112 N471JROrtiz Rivera Jose E · Bayamon, PRBuilt 1972 · S/N 17260933 N471PRRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1973 · S/N 17262016 N4720BAffiliated Air Services Inc · Vincentown, NJBuilt 1979 · S/N 15283596 N4720CNesbit Gary M · West Linn, ORBuilt 1979 · S/N 21063601 N4720PKlingler Larry R · Wolfeboro, NHBuilt 1978 · S/N P21000090 N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016 N4720YKraemair Aviation LLC · Sauk City, WIBuilt 1980 · S/N 21063992 N4721BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283597 N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017 N4722PEac Property Management LLC · Atlanta, GAS/N 240245 N4723BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283598 N4723PChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 15284804 N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018 N4723TPrs Holdings Inc · Jurupa Valley, CABuilt 1981 · S/N R18201744 N4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 21063993 N47253De Wan Madisun Nicole · Tarpon Springs, FLBuilt 1979 · S/N 15283198 N4725DClover Park Technical College · Tacoma, WABuilt 1979 · S/N 17272340 N4725GRegistration Pending · Tampa, FLRegistration pendingS/N 17273330 N47261Future American Aviators LLC · Davie, FLS/N 15283204 N47268Jones Benn D · Bell, FLBuilt 1979 · S/N 15283206 N4726BMurray Kenneth · Parkville, MDBuilt 1979 · S/N 15283600 N4726ESky Hopper LLC · San Jose, CABuilt 1982 · S/N 18268262 N4726GAckerman Timothy M · Barnesville, OHS/N 17273331 N4726QBecker Flying Service Inc · Hartington, NEBuilt 1976 · S/N 18802496T N4726YMeisner David B · Meridian, IDBuilt 1980 · S/N 21063994 N4727D4 Leaf Clover Leasing LLC · Murrieta, CABuilt 1979 · S/N 17272341 N4727GDelaney Patrick · Marion, TXS/N 17273332 N4727HJet & Rotor Aviation LLC · Sacramento, CABuilt 1979 · S/N 15283971 N4728GHidalgo Ciro R · Granbury, TXS/N 17273333 N4728TThree Prop LLC · Dallas, TXBuilt 1981 · S/N R18201746 N4729CSullivan David C · St George, UTBuilt 1979 · S/N 21063604 N472ACSwift Air LLC · Lebanon, TNS/N 411-98 N472JSTaylor Kirk B · Houston, TXS/N 17701730 N472KPB2 West Corp · Winona, MNBuilt 1981 · S/N 172RG0922 N4730BPotter Jay O · Charlotte, NCBuilt 1979 · S/N 15283602 N4730HMoore Performance Aircraft LLC · Jenks, OKBuilt 1979 · S/N 24-0827 N4732VGeneral Aviation Support Corp · Rosamond, CABuilt 1980 · S/N 172RG0371 N4733DWycoff Shannon M · Baton Rouge, LABuilt 1979 · S/N 17272344 N4734ANewman Macy M · Plano, TXBuilt 1979 · S/N A1520885 N47354Wings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283220 N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092 N4735TUlrich Dennis · London, KYS/N R18201747

Back to AD 80-25-07 R1