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.

N5478TSipes David · Bolivar, TNBuilt 1964 · S/N 17251378 N5479DSpanaflight LLC · Puyallup, WABuilt 1979 · S/N 17272581 N5479RLott Brian K · Nixa, MOBuilt 1974 · S/N 17263545 N547ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281596 N547EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13541 N547NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11049 N54803Northwoods Air LLC · Orono, MEBuilt 1981 · S/N 17275054 N5480EColgan Aviation LLC · La Crosse, WIBuilt 1978 · S/N 17271877 N5480KAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274146 N54812E & E Aviation LLC · Kingshill, VIS/N 17275056 N5481RBirk Gregory R · Charleston, MOBuilt 1965 · S/N 17253045 N54829Aviate LLC DBA · Hazelton, IDBuilt 1981 · S/N 17275059 N5482RBrown Wesley P · Gillette, WYBuilt 1965 · S/N 17253046 N54832Maskityj LLC · Hagerstown, MDBuilt 1981 · S/N 17275061 N54838Draco Flight School DBA · Chino, CABuilt 1981 · S/N 17275064 N5483KIzzo Michael D · Phoenix, AZBuilt 1980 · S/N 17274149 N54844Dynasty Adventure Inc · Mentone, CABuilt 1981 · S/N 17275065 N54849Colorado Northwestern Community College · Rangely, COBuilt 1981 · S/N 17275066 N5484DAerobiz LLC · Lewes, DEBuilt 1979 · S/N 17272583 N5484RCarlisle Herbert F · Tulia, TXBuilt 1965 · S/N 17253049 N5484TWings Den LLC · Wilmington, DEBuilt 1964 · S/N 17251384 N54855Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275068 N5485HGiron Lawrence · Anchorage, AKBuilt 1975 · S/N 17265461 N5485KBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N 17274151 N5485TJohnson Warren A · Delavan, WIS/N 17251385 N5486DFord Bernard DBA · Sidney, NYBuilt 1979 · S/N 17272585 N5487KRingen Marvin O · Beaverton, ORS/N 17274153 N5488DCardoso Roberto Y · Montclair, CAS/N 17272586 N5489RBrodmerkel Lisa C · Georgetown, PABuilt 1965 · S/N 17253055 N5489TDunn Scott · Warren, OHBuilt 1964 · S/N 17251389 N548ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281597 N548EPGulf Coast Aviation LLC · New Orleans, LABuilt 2007 · S/N 172S10530 N548EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13544 N548NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S11050 N548SPMinter Barry · Rockport, MOBuilt 2000 · S/N 172S8401 N54905905 Cess LLC · Wilmington, DEBuilt 1981 · S/N 17275076 N5490HSuperior Flying Services LLC · Superior, WIS/N 17265462 N54910Somboonsap Patanapong · Oakland Park, FLBuilt 1981 · S/N 17275077 N5491HSky Hogs LLC · Orange Park, FLBuilt 1975 · S/N 17265463 N5491JChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10395 N5491KSale Reported · Rowland, NCSale reportedBuilt 1980 · S/N 17274156 N5491RSingh Jaspal · Sacramento, CABuilt 1965 · S/N 17253058 N5491TAlpha Mike LLC · Stoughton, MABuilt 1964 · S/N 17251391 N5492HAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1975 · S/N 17265464 N5492TCollins Terry D · Maynardville, TNBuilt 1964 · S/N 17251392 N5493RFreedom Flight Center Inc · Hardy, NEBuilt 1979 · S/N 172RG0064 N54946Goosfraba LLC · Huddleston, VABuilt 1981 · S/N 17275084 N54947Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275085 N54951Skylens LLC · Hammond, LABuilt 1981 · S/N 17275087 N54955Space 5 LLC · Fayetteville, GABuilt 1982 · S/N 17275089

Back to AD 90-06-03 R1