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.

N37JAFlying Start Aero Services LLC · Reno, NVBuilt 1997 · S/N 17280095 N37LFWalter Cheri L · Hampshire, ILBuilt 1966 · S/N 17254460 N37MTBeaver Valley Flying Club Inc · Beaver Falls, PABuilt 1999 · S/N 172S8205 N37SDAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13250 N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035 N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385 N3800SThompson Troy L · Limon, COBuilt 1963 · S/N 17251000 N3801LSouth Mark B · Eastanollee, GAS/N 17253970 N3802LHill Herman J · Corvallis, MTBuilt 1965 · S/N 17253971 N3803LHanna R Brian · Tallahassee, FLBuilt 1965 · S/N 17253972 N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903 N3803SReid Aviation LLC · Boise, IDBuilt 1963 · S/N 17251003 N3804LAeroelite Solutions LLC · Kalispell, MTBuilt 1965 · S/N 17253973 N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904 N3804RVorhees Tyler R · Rockford, ILBuilt 1966 · S/N 17255304 N3804SSilvers Morris · Burnsville, NCS/N 17251004 N3805LVelasquez Veronica R · San Antonio, TXBuilt 1965 · S/N 17253974 N3805SWenk Mark J · Lakewood, PABuilt 1963 · S/N 17251005 N3806RMartin Gary J · Glasgow, MTBuilt 1966 · S/N 17255306 N3808LGreensburg Jeanette Airport Administration · Jeannette, PAS/N 17253977 N3809LSale Reported · Oak Harbor, WASale reportedS/N 17253978 N3809RImhof Donald R · Central City, NEBuilt 1966 · S/N 17255309 N3809SPhillippi Victor L · Broadus, MTBuilt 1963 · S/N 17251009 N380LAPounders Brent · Prosper, TXS/N 17253570 N380MEVpc Air Inc · Cartersville, GABuilt 2000 · S/N 172S8559 N3810SGrant Sidney Tucker · La Porte, TXBuilt 1963 · S/N 17251010 N3811SFuist Richard A · Lake City, FLBuilt 1963 · S/N 17251011 N3812LAune Todd A · Harlingen, TXBuilt 1966 · S/N 17253981 N3813LBuyak David W · New Hartford, CTBuilt 1965 · S/N 17253982 N3813SHughes Todd R · Rocky Ford, COS/N 17251013 N3814SRegistered aircraftBuilt 1963 · S/N 17251014 N3815LCordova Tomy · Hastings, MIBuilt 1965 · S/N 17253984 N3815SRickard Hudson · Cleveland, OHBuilt 1963 · S/N 51015 N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916 N3817QMoses Aviation Services LLC · Uvalde, TXS/N 17259917 N3817SLake Kris E · Wasilla, AKBuilt 1963 · S/N 17251017 N3818QRanch Hand Flying Club Inc · Gardiner, NYBuilt 1972 · S/N 17259918 N3818RRuddle Aviation LLC · Lawrenceburg, TNBuilt 1966 · S/N 17255318 N3819LRay Aviation LLC · Burkett, TXBuilt 1965 · S/N 17253988 N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919 N3819RMeznarsic Victor F · Alton, ILBuilt 1966 · S/N 17255319 N381CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12139 N381DFSouth & Silver Aviation LLC · Pikesville, MDBuilt 1977 · S/N 17269718 N381ESFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280081 N381JUS Aviation Group LLC · Denton, TXBuilt 1980 · S/N 17274183 N381MBStrobridge Mark D · Bunnell, FLBuilt 1981 · S/N 17275303 N381MGMissionary Air Group Inc · Burlington, NCBuilt 1975 · S/N 17265873 N3820SSchrader Jerome · Rocklin, CABuilt 1964 · S/N 17251020 N3821LSky Bryce Flying Club LLC · Basye, VABuilt 1965 · S/N 17253990 N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922

Back to AD 90-06-03 R1