Registered aircraft · 25,368

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.

N9571VTempleton John E · Loami, ILBuilt 1974 · S/N 17264373 N95722Frick Gregory A · Portland, ORBuilt 1985 · S/N 15285962 N9572HGeneral Aviation LLC · Henderson, NVBuilt 1975 · S/N 17266237 N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582 N9572VHill Timothy E · Hooks, TXBuilt 1974 · S/N 17264374 N95737Kent State University · Stow, OHBuilt 1985 · S/N 15285964 N9573BDocarmo Aviation LLC · Dallas, TXBuilt 1981 · S/N 172RG0890 N9573MAndrews Geoffrey M · Stoneham, MABuilt 1966 · S/N 670150 N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66 N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375 N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891 N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238 N9574SKrejchik Daniel J · Portage, WIBuilt 1965 · S/N 14 N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377 N9576GWerth Lance C · Johnson Lake, NEBuilt 1974 · S/N 18801542 N9576MRpm Commander Holdings Inc · Vero Beach, FLS/N 670153 N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894 N9577MStaton Jered · Rochester, MNBuilt 1966 · S/N 670154 N9577SConner Harvey E · Coahoma, TXS/N 368 N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379 N9577YShort Notice Inc · Pensacola, FLBuilt 1981 · S/N 21064552 N95787Wisconsin Aviation - Four Lakes Inc · Madison, WIBuilt 1985 · S/N 15285967 N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895 N9578SSlone Donald L · Holden, MOS/N 320 N95797Kent State University · Stow, OHBuilt 1985 · S/N 15285968 N9580MRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1966 · S/N 670157 N9580SSkyvault Holdings LLC · Saint Petersburg, FLBuilt 1965 · S/N 30 N9581SKing John D · Midland, VABuilt 1966 · S/N 192 N95821Kent State University · Stow, OHBuilt 1985 · S/N 15285970 N9582HMiller Timothy · Saratoga, CABuilt 1975 · S/N 17266244 N9582VCady Craig D · New Braunfels, TXBuilt 1974 · S/N 17264384 N95831Space Coast Aircraft Co · Merritt Island, FLBuilt 1985 · S/N 15285972 N9583BBurke Larry Ryan · Pembroke, GABuilt 1981 · S/N 172RG0898 N95840Lane Community College · Eugene, ORBuilt 1985 · S/N 15285973 N9584B360 Marine · Bristol, RIBuilt 1981 · S/N 172RG0899 N9584MKing Wesley C Jr · Dayton, OHBuilt 1966 · S/N 670161 N9584SWalker James M Jr · Springfield, KYBuilt 1965 · S/N 334 N9584VStick & Rudder Club Inc · Waukegan, ILBuilt 1974 · S/N 17264386 N9585MScheuneman Carl V · Plano, TXBuilt 1966 · S/N 670162 N9585VHarrington Aviation LLC · Scarborough, MEBuilt 1974 · S/N 17264387 N9586MH W S Enterprises Inc · Canal Fulton, OHBuilt 1966 · S/N 670163 N9587MNorman Bradley T · Glen Rose, TXBuilt 1966 · S/N 670164 N9587SReberg Timothy J · Bayport, MNBuilt 1965 · S/N 5 N9587VPinnick Brent E · West Baden Springs, INBuilt 1974 · S/N 17264389 N9588MDrietz Dallas A · Lake Benton, MNBuilt 1966 · S/N 670165 N9588VKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17264390 N9589HFryar Scott D · Starke, FLBuilt 1975 · S/N 17266248 N9589SJones Daniel S · Panama City Beach, FLBuilt 1965 · S/N 9 N958SBVictor Foxtrot LLC · Scott City, KSBuilt 1979 · S/N R18200954 N9590MRegistration Pending · Paynesville, MNRegistration pendingBuilt 1966 · S/N 670167

Back to AD 80-25-07 R1