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.

N374SPSkiles Richard L · Wimberley, TXBuilt 2003 · S/N 172S9503 N3750FGrubbs Richard T · Spring, TXBuilt 1966 · S/N 17255245 N3750RN3750r LLC · Guthrie, OKBuilt 1966 · S/N 17255550 N3752FCopper River Airmotive LLC · Copper Center, AKS/N 17255247 N3752RMccoy Gregory K · Wichita, KSBuilt 1966 · S/N 17255552 N3752SHutchins Mary Ellen · Front Royal, VABuilt 1963 · S/N 17250952 N3753LKroutil David W · Hilmar, CABuilt 1965 · S/N 17253922 N3753RCounts Sean M · Largo, FLBuilt 1966 · S/N 17255553 N3754FTrees Joshua S · Italy, TXBuilt 1966 · S/N 17255249 N3754LBuist Gordon G · Southbury, CTBuilt 1965 · S/N 17253923 N3754RVandiver James A · Rome City, INBuilt 1966 · S/N 17255554 N3755LNorcal Flight Center LLC · Lincoln, CAS/N 17253924 N3757SWiller Sebastian · Calhoun, GABuilt 1963 · S/N 17250957 N3758FTvpx Aircraft Solutions Inctrustee · North Salt Lake, UTS/N 17255253 N3758LN3758l LLC · Titusville, FLBuilt 1965 · S/N 17253927 N3758RDrager Timothy L · Pottstown, PABuilt 1966 · S/N 17255558 N3758SMorris Philip N · Edgewood, NMBuilt 1963 · S/N 17250958 N3759SBudd Stephen C · Lake City, FLBuilt 1963 · S/N 17250959 N375LARegistered aircraftBuilt 1965 · S/N 17252722 N375MASteinhardt Clark R Jr · Green Bay, WIBuilt 1999 · S/N 172S8077 N375YVBisono Pablo R · San Juan, PRBuilt 1974 · S/N 17262930 N3760SPorter Charles T III · Seymour, TXBuilt 1963 · S/N 17250960 N3761LBas Part Sales LLC · Greeley, COS/N 17253930 N3761SBucks Flight Academy LLC · Cashion, OKBuilt 1963 · S/N 17250961 N3763RPrimo Aviation LLC · Collierville, TNBuilt 1966 · S/N 17255563 N3763SGriffn Jared · Sheridan, ARBuilt 1963 · S/N 17250963 N3764SKarashchuk Yaroslav P · Georgetown, KYS/N 17250964 N3765RLevin Robert · Roseburg, ORBuilt 1966 · S/N 17255565 N3766LSygnet Lenard M · Pottstown, PABuilt 1965 · S/N 17253935 N3767SDickehut Donna · Cloverdale, INBuilt 1963 · S/N 17250967 N3768RStretz Scott P · Lees Summit, MOBuilt 1966 · S/N 17255568 N376SPTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2003 · S/N 172S9508 N3770FSchoenberger Lance · Shakopee, MNBuilt 1966 · S/N 17255265 N3770LJ&C Aviation LLC · South Boston, VABuilt 1965 · S/N 17253939 N3770RBowery Michael P · Quinton, VABuilt 1966 · S/N 17255570 N37718Cole Rayce S · Palmer, AKS/N 46597 N3771LFlying Bs LLC · Midlothian, TXBuilt 1966 · S/N 17253940 N3771RMccay Brian D · Earlysville, VABuilt 1966 · S/N 17255571 N3772RRiver Town Aviation LLC · Williamstown, WVBuilt 1966 · S/N 17255572 N3772SThree Strands LLC · Colorado Springs, COBuilt 1963 · S/N 17250972 N3773RBlair Richard J · Medina, OHS/N 17255573 N3773SFielden Donald J · Bartow, FLBuilt 1963 · S/N 17250973 N3774LKarr Stacy A · Hogansville, GABuilt 1965 · S/N 17253943 N3775LLee Michael Min · Dayton, OHBuilt 1965 · S/N 17253944 N3776FRegistration Pending · Denver, NCRegistration pending, pending cancellationS/N 17255271 N3776LStramel Bert Jon · Colby, KSBuilt 1965 · S/N 17253945 N3778RSwede Aviation LLC · Tucson, AZBuilt 1966 · S/N 17255578 N3779FTiraphatna Jittakorn · Arlington, TXS/N 17255274 N3779SShawver Aviation LLC · Knoxville, IABuilt 1963 · S/N 17250979 N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086

Back to AD 90-06-03 R1