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.

N1497YHall Robert D · Prince-Frederick, MDBuilt 1962 · S/N 17249197 N1498VMoore James E · East Falmouth, MABuilt 1974 · S/N 17263628 N1499YHockenberry Randall L · Cape Coral, FLBuilt 1962 · S/N 17249199 N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119 N149LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13125 N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185 N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735 N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062 N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844 N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528 N14WAWright Brandon C · Cave City, KYBuilt 1966 · S/N 17254217 N14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeBuilt 2019 · S/N 172S12415 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N1501YStreeter Christopher D · Vinita, OKBuilt 1962 · S/N 17249201 N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N1506YVaughn Jeffery Page · Shenandoah, VAS/N 17249206 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N150SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11565 N150TESummit Air LLC · San Diego, CABuilt 2009 · S/N 172S10996 N150TH150th Aero Flying Club · Morristown, NJBuilt 2003 · S/N 172S9453 N1510YEegle Corps Inc · Wilmington, DEBuilt 1962 · S/N 17249210 N15138Lone Star Flight Museum · Houston, TXBuilt 1967 · S/N R1720133 N1516VAircraft Management Services Inc · Milton, FLBuilt 1974 · S/N 17263638 N1517EHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 1978 · S/N 17271031 N1519VBent Prop LLC · Inver Grove, MNBuilt 1974 · S/N 17263641 N1519YHarrison Michael R · Woodbine, MDBuilt 1962 · S/N 17249219 N151VUVincennes University · Indianapolis, INBuilt 1980 · S/N 172RG0667 N1520YScott Thomas A Jr · Lawrenceburg, TNBuilt 1962 · S/N 17249220 N15222Southeast Aircraft Leasing LLC · Jacksonville, FLBuilt 2007 · S/N 172S10454 N1522RN1522r LLC · Mequon, WIBuilt 2008 · S/N 172S10716 N1522VDawn Patrol Flying Club Inc · Northville, MIBuilt 1974 · S/N 17263643 N1522YKinard Phillip · Tuscaloosa, ALBuilt 1962 · S/N 17249222 N1523VSchmitz Barbara B · Oshkosh, WIBuilt 1974 · S/N 17263644 N1523YRegional Air Inc · Lawton, OKS/N 17249223 N15255Elizabeth City State University · Elizabeth City, NCBuilt 2007 · S/N 172S10455 N1526VRl Aviation LLC · Miami, FLBuilt 1974 · S/N 17263645 N1527YEshman Daniel J Jr · Bryan, OHS/N 17249227 N1528YTexoma Aero Club · Denison, TXBuilt 1962 · S/N 17249228 N1529YBirge Darrell W · Linden, INS/N 17249229 N152SAXd Aviation LLC · Castle Rock, COBuilt 2013 · S/N 172S11275 N1530YCall Richard T · Wasilla, AKBuilt 1962 · S/N 17249230 N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648 N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038 N1534YLipsmeyer Jason K · Springdale, ARS/N 17249234 N1535YTheriault John · Harvard, ILBuilt 1962 · S/N 17249235

Back to AD 90-06-03 R1