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.

N4532HAdvanced Flight Systems Inc · Canby, ORBuilt 1979 · S/N 24-0792 N45336Kelley Joshua S · Anchorage, AKBuilt 1976 · S/N 177RG1107 N4533JStevens Investment Group LLC · Elsie, MIBuilt 1980 · S/N T18803745T N45349Wall Johan D · Brookston, TXBuilt 1976 · S/N 177RG1109 N4534E34 Echo Group · Spring Branch, TXBuilt 1978 · S/N 17271622 N45359Clapp Edwin G III · Fargo, NDBuilt 1976 · S/N 177RG1112 N4535HMurray Brent S · Great Falls, MTBuilt 1979 · S/N 24-0793 N45367Christensen Robert T · Presho, SDBuilt 1976 · S/N 177RG1113 N4536HColorado Flight Operations LLC · Colorado Springs, COBuilt 1979 · S/N 24-0794 N45385Steklenski Philip G · Olympia, WABuilt 1977 · S/N 177RG1117 N4538EGrasshopper Flying Club Inc · Poughkeepsie, NYBuilt 1978 · S/N 17271623 N453PTHenrie Aviation LLC · Fairfield, NJBuilt 1984 · S/N 17276262 N453WMAerostar Companies Inc · Dover, DEFirst renewal noticeBuilt 1978 · S/N R18200828 N4547EG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17271626 N454BMCorman David L · Lovington, ILBuilt 1972 · S/N 17260799 N454DMGerman George Derlin · Petaluma, CABuilt 1979 · S/N R18201162 N4550EPommy & Swede LLC · Valentine, NEBuilt 1978 · S/N 17271628 N4555WSan Diego Aerobatics LLC · San Diego, CABuilt 1976 · S/N 0741 N4558HTjr Inc · Bellevue, NEBuilt 1979 · S/N 24-0765 N455AFN455af LLC · Toquerville, UTBuilt 1968 · S/N 17701336 N455ETLakes Aircraft Inc. · Maumee, OHBuilt 1975 · S/N 0711 N455GBBrs Leasing Inc · Wilmington, DEBuilt 1982 · S/N 15285455 N455RTSouthern Genesis Aero LLC · Midland City, ALBuilt 2000 · S/N 447-2000 N4564HSwanson Terence S · Montrose, COBuilt 1965 · S/N 3006 N4566HBeresford Emil E · Cape Coral, FLBuilt 1979 · S/N 24-0848 N45677Davidson Christopher Scott · Friant, CABuilt 1977 · S/N 177RG1126 N4568FWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282989 N4569HPowell Randy N Trustee · Elko, NVBuilt 1979 · S/N 24-0849 N456BHCastleton Real Estate & Developlment Inc · El Monte, CAS/N R18201482 N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N456CWSale Reported · Fort Denaud, FLSale reportedBuilt 1982 · S/N 21064676 N456DJSingle Raj Pa Inc · Seattle, WABuilt 1982 · S/N R18201888 N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97 N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220 N4574VSmtm Holdings Inc · Wilmington, DES/N 17266358 N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222 N457ACBrown David R · Niceville, FLBuilt 1999 · S/N 414-99 N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589 N457MCBoguy Air LLC · Kingstree, SCBuilt 1974 · S/N 466-74 N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736 N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223 N45835Yoakam John A · North Ridgeville, OHS/N 177RG0756 N4583HPiehler David A · Wausau, WIBuilt 1979 · S/N 24-0852 N4590BFulltron Aviation LLC · Springfield, MOBuilt 1979 · S/N 15283545 N4590PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284774 N45915Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 15282943 N4591HCampbell James R · Bennett, COBuilt 1979 · S/N 24-0855 N45928Cohan Thomas A · Sparks, NVBuilt 1978 · S/N 15282945 N4593VFranklin Eric J · Anchorage, AKBuilt 1980 · S/N 172RG0330

Back to AD 80-25-07 R1