Skip to content

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.

N4677LJet Airways Express Inc · Aventura, FLBuilt 1966 · S/N 17254672 N4679GFlightime Inc · Elkhart, INS/N 17273305 N4679LFitting Solutions Lc · Chester, NJBuilt 1966 · S/N 17254674 N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859 N467ERWingsleasing LLC · Wichita, KSS/N 172S10287 N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649 N4680LWasilowski Steven P · Elgin, ILBuilt 1966 · S/N 17254675 N4681LOmer Syeda · Gilroy, CAS/N 17254676 N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330 N4682LJones Carl R · Little Rock, ARBuilt 1966 · S/N 17254677 N4683GDeichert Ryan L · Bismarck, NDS/N 17273309 N4683LLawson Seth A · Morgantown, WVBuilt 1966 · S/N 17254678 N4684LHowell Tyler L · Romoland, CABuilt 1966 · S/N 17254679 N4685LEsquilin Steven C · Poway, CABuilt 1966 · S/N 17254680 N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365 N4687LKful Inc · Fullerton, CABuilt 1966 · S/N 17254682 N4687VSharp Cutlass LLC · Iowa City, IABuilt 1980 · S/N 172RG0366 N4688LFas Aircraft Aerowork Corp · Miami, FLBuilt 1966 · S/N 17254683 N468CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280860 N468EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12659 N4691GLr Properties LLC · Goodyear, AZS/N 17273317 N4692GJz Air LLC · Brooklyn, NYS/N 17273318 N4692LBravo Aviation LLC · Rexburg, IDS/N 17254687 N4692QZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1973 · S/N 17261745 N4693JThibodeaux Gerald J · Duson, LABuilt 1979 · S/N 17273663 N4693LEmerald Air LLC · Snohomish, WABuilt 1966 · S/N 17254688 N4693QSievert David M · Santa Cruz, CABuilt 1973 · S/N 17261746 N46940Registration Pending · Como, MSRegistration pendingBuilt 1967 · S/N 17255577 N4694GRegistered aircraftBuilt 1979 · S/N 17273320 N4694LSky Tours LLC · Port Clinton, OHBuilt 1966 · S/N 17254689 N4695LRoss Richard R · Mckinney, TXBuilt 1966 · S/N 17254690 N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073 N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691 N4697GVeety Roy D · Dalton, PAS/N 17273323 N4697LTverberg Justin T · Omak, WABuilt 1966 · S/N 17254692 N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333 N469ERMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8940 N469FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10884 N469MBFloriflt LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9944 N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952 N46FFFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12874 N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942 N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144 N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074 N4704GRegistration Pending · Spencerville, OHRegistration pendingS/N 17273326 N4705DN4705d LLC · Oklahoma City, OKS/N 17272335 N4706DKelly William W · Springfield, ORBuilt 1979 · S/N 17272336 N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013 N470EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11599 N470FSCustom Air International LLC · Homestead, FLBuilt 1973 · S/N 17262011

Back to AD 90-06-03 R1