Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N515LXJones Johnny V · Crab Orchard, KYS/N 17250603 N515RDWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264049 N515SPFriedlander Ernest · San Francisco, CABuilt 2000 · S/N 172S8374 N5160ABowden Aaron C · Yuma, AZBuilt 1955 · S/N 28160 N5160ELeading Edge Flight Academy LLC · Bend, ORBuilt 1978 · S/N 17271744 N5160RTownley Wren Adam T · Orwell, VTS/N 17263377 N51614Stillwater Flyers LLC · Columbus, MTBuilt 1981 · S/N 17274330 N51616Stardust Aviation LLC · Farmingdale, NYBuilt 1980 · S/N 17274331 N5161ASchmid Robert E · Red Bluff, CABuilt 1955 · S/N 28161 N5162ASizer Timothy J · Arthur, NES/N 28162 N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120 N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379 N51637South Dakota State University · Brookings, SDS/N 172S9033 N5163APassero Robert S · Madison, ALBuilt 1955 · S/N 28163 N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438 N5163HLsn Air LLC · Morrison, COBuilt 2001 · S/N 172S8933 N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267 N5163VKopacz Thomas · Glen Flora, WIBuilt 1980 · S/N 172RG0457 N5163ZGevojanyan Gary · Burbank, CAS/N 172S9032 N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746 N5165AKulp Robert E Jr · Cartersville, GABuilt 1955 · S/N 28165 N5165MAl & Zal Corp · Gaylord, MIBuilt 2002 · S/N 17281092 N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382 N5166ADavis Barry E · Carrollton, GABuilt 1955 · S/N 28166 N5166FColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17253052 N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383 N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336 N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747 N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357 N5168VSky-Vu Flyers Inc · Fishers, INS/N 172S9037 N5169EVenbro Holdings LLC · Brooklyn, NYBuilt 2002 · S/N 172S9038 N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458 N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205 N516CSMccullough Construction Inc · South Jordan, UTBuilt 1998 · S/N 17280428 N516EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12867 N516JWAerostar LLC · Newport Beach, CABuilt 1975 · S/N 17265201 N516NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2008 · S/N 172S10786 N516SPOrlando Aeroclub Inc · Orlando, FLBuilt 2000 · S/N 172S8375 N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889 N51700Brown County Flying Club · Aberdeen, SDBuilt 1980 · S/N 17274338 N5171AInfinity Metalworks Inc · Newton, KSBuilt 1955 · S/N 28171 N5171HPan Air Flying Club · Miami, FLBuilt 1975 · S/N 17265358 N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998 N5171RSamuels Jay M · East Tawas, MIBuilt 1974 · S/N 17263388 N5171USummers Jeffrey L · Pekin, INBuilt 1980 · S/N 172RG0272 N5172ABarnes Timothy Edward · Stephenville, TXBuilt 1955 · S/N 28172 N5172HMsi Fuel Management Inc · Vacaville, CABuilt 1975 · S/N 17265359 N5172WOcala Aviation Services Inc · Ocala, FLBuilt 2002 · S/N 172S9043 N5173VEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9046 N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342

Back to AD 90-06-03 R1