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.

N4987RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256341 N4989RLansing Community College · Mason, MIBuilt 1967 · S/N 17256343 N498EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11603 N498SPBmg Aviation Inc · Bloomington, INBuilt 1998 · S/N 172S8039 N4990RSmith Joshua B · Kenai, AKBuilt 1967 · S/N 17256344 N4991BStapleton Kenneth E · Nocona, TXBuilt 1965 · S/N 17252588 N4994ELaforest David C · Hudson, MIBuilt 1978 · S/N 17271688 N499CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12510 N499DRWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 172S9167 N499EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11604 N499KWRidgeline Assets LLC · Wilmington, DEBuilt 2000 · S/N 172S8430 N49CGLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17262238 N49MQSgl Aviation LLC · Fairfield, NJBuilt 1976 · S/N 17267703 N49RHChristiansen Aviation LLC · Wilmington, DES/N 172S12932 N49RLMartineau Aircraft Inc · Butte, MTBuilt 1976 · S/N 17267002 N49RZHappy Airplanes LLC · San Antonio, TXBuilt 1977 · S/N 17270001 N4AMPacific Northwest Aircraft Leasing LLC · Kirkland, WAS/N 17274273 N4EBDaro Norman E · Cody, WYBuilt 1972 · S/N 17260518 N4NPSkywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17274731 N4QPN4qp LLC · Union Gap, WABuilt 2020 · S/N 172S12429 N4RKMeyer Richard D · Clanton, ALBuilt 1964 · S/N 17251797 N4SWSalem Airport Authority · Salem, ILBuilt 1974 · S/N 17263276 N4TAColumbia Aviation Inc · Columbia, TNBuilt 1973 · S/N 17262298 N50000White Barry E · Abbeville, SCS/N 17250145 N5000AOzment Dennis W · Palmyra, MOBuilt 1955 · S/N 28000 N5000YSutter Street Holdings LLC · Santa Monica, CABuilt 2008 · S/N 172S10868 N50011Taco George Aviation LLC · Coppell, TXBuilt 2008 · S/N 172S10865 N5001ADavis Anthony S · Homeland, CABuilt 1955 · S/N 28001 N5001UOew Aviation LLC · Sumter, SCBuilt 2001 · S/N 172S8959 N5002ABrown Richard J · Lexington, TNS/N 28002 N5003AOverton Tommy D Sr · Clinton, LABuilt 1955 · S/N 28003 N5004AMoore Kelly N · Anchorage, AKBuilt 1955 · S/N 28004 N5004YElon Aviation LLC · Burlington, NCBuilt 2001 · S/N 172S8961 N5005AWood Ryan H · Anchorage, AKBuilt 1955 · S/N 28005 N5005RBaer Michael E · Wheaton, ILBuilt 1974 · S/N 17263246 N50067Prop Wash Aviation LLC · Hayward, WIS/N 17272811 N5006ASmokovitz Joseph M · Tecumseh, MIBuilt 1956 · S/N 28006 N5007AWallace Christopher S H · Cleburne, TXBuilt 1955 · S/N 28007 N5009AOgorek Peter J · Milwaukee, WIBuilt 1955 · S/N 28009 N500BBHinton Glynn E · Slidell, LABuilt 1962 · S/N 17249768 N500BSCentral Aircraft Sales And Leasing LLC · Columbia, MOBuilt 1971 · S/N 17260303 N500DZEz Aviation LLC · Orlando, FLFirst renewal noticeS/N 172RG0362 N500GDElizondo Ernesto · Laredo, TXBuilt 1976 · S/N 17267505 N500GPEhg Flight LLC · Venice, CABuilt 1998 · S/N 17280500 N500TFPine Bluff Police Department · Pine Bluff, ARBuilt 1977 · S/N 17268711 N5011ABores Scott J · Huron, OHS/N 28011 N5011UAtp Aircraft 2 LLC · Wilmington, DEBuilt 2008 · S/N 172S10881 N5013AReed Ted R · San Angelo, TXBuilt 1955 · S/N 28013 N5013RBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263254 N5016AMoore Wallace Frank · Mckinney, TXBuilt 1955 · S/N 28016

Back to AD 90-06-03 R1