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.

N5174AWells Lavar W · Hanksville, UTBuilt 1956 · S/N 28174 N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752 N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360 N5175ADenkema Richard S · Grand Rapids, MIBuilt 1955 · S/N 28175 N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753 N5175YLutz Aviation LLC · Perkinsville, VTBuilt 2002 · S/N 172S9050 N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044 N5176VVangorder Donna · Greenwood, ARS/N 172RG0459 N5177AHolden Daniel N · Anacortes, WAS/N 28177 N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361 N5178FTurrentine Danny H · Wolfe City, TXBuilt 1965 · S/N 17253100 N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395 N5178SG & M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 17281097 N5178USoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281098 N5178YSoutheastern Oklahoma State University · Durant, OKS/N 17281099 N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347 N51794Christiansen Aviation LLC · Wilmington, DES/N 17274348 N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362 N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460 N517CAFisher Richard L Jr · Saint Helens, ORS/N 17268100 N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965 N517NDSunrise Aviation Inc · Ormond Beach, FLS/N 172S10787 N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318 N51800Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281101 N51804Summit Aviation Inc · Belgrade, MTBuilt 2009 · S/N 172S10898 N5180AWarmack Holdings LLC · Englewood, FLBuilt 1956 · S/N 28180 N5180FUnited States Air Force Owner · Hanscom Afb, MABuilt 1965 · S/N 17253108 N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397 N5181ASoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281102 N5181BSoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281103 N5181EMustang Sally Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9058 N5181HRegistered aircraftBuilt 1975 · S/N 17265363 N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398 N51827B D Aviation LLC · Sauget, ILBuilt 2002 · S/N 17281108 N5182AIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281106 N5182ERegistered aircraftBuilt 1978 · S/N 17271756 N5182FAmerican Flight Museum Inc · Topeka, KSBuilt 1965 · S/N 17253116 N51832Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 17274357 N5183ENashville Flight School LLC · Nashville, TNS/N 17271757 N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400 N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359 N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758 N5184FScott Alan M · Othello, WABuilt 1965 · S/N 17253124 N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721 N5185ACardan Aircraft Services Inc · Red Bluff, CAS/N 28185 N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441 N5185UMoyer Aviation Inc · Tobyhanna, PABuilt 2002 · S/N 172S9059 N5185YPiedmont Flight Inc · Winston Salem, NCBuilt 2002 · S/N 172S9060 N51864Zita Air LLC · Lewisburg, PABuilt 1980 · S/N 17274361 N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362

Back to AD 90-06-03 R1