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.

N3870LStraub Brian L · Queensbury, NYBuilt 1965 · S/N 17254039 N3870QLake Waccamaw Aviation LLC · Lake Waccamaw, NCBuilt 1971 · S/N 17259970 N3870SCherryhill Aviation Inc · Freetown, INBuilt 1963 · S/N 17251070 N3872LMaletich Steven J · Las Vegas, NVBuilt 1965 · S/N 17254041 N3872QGibbs Elizabeth A · Bellingham, WABuilt 1971 · S/N 17259972 N3872RS&Sa Aviation LLC · Colby, KSBuilt 1966 · S/N 17255372 N3872SNeu Aviation LLC · Benton, LABuilt 1963 · S/N 17251072 N3873QSkywalker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17259973 N3873RFoster William G Jr · Sunnyvale, CABuilt 1966 · S/N 17255373 N3874RMartig Glenn A · Lino Lakes, MNBuilt 1966 · S/N 17255374 N3875LBazemore Robert J · Butler, GAS/N 17254044 N3875QAerial Scouting Solutions LLC · Sioux Center, IABuilt 1971 · S/N 17259975 N3875SFlying M Enterprises · Loomis, NEBuilt 1963 · S/N 17251075 N3876LWoerle Edward R · Rossville, TNS/N 17254045 N3876QKracke Spraying Service Inc · Fargo, NDBuilt 1971 · S/N 17259976 N3876RTriple Farms DBA · Sikeston, MOBuilt 1966 · S/N 17255376 N3876SMustoe William J Jr · Summersville, WVBuilt 1963 · S/N 17251076 N3878LLatshaw Sonja · Vero Beach, FLBuilt 1965 · S/N 17254047 N3878RSs Farms Operating LLC · Hydro, OKBuilt 1966 · S/N 17255378 N3878SSkyhawk172 LLC · Gainesville, TXBuilt 1963 · S/N 17251078 N3879LThielemann Kate Ann · Inverness, FLBuilt 1966 · S/N 17254048 N387AFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2006 · S/N 172S10387 N387DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12652 N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387 N387SPMsb Aviation LLC · Rockvale, TNBuilt 1999 · S/N 172S8284 N3880QJ&J Hangars LLC · Newnan, GABuilt 1971 · S/N 17259980 N3880RC172 Nancy LLC · Euclid, OHS/N 17255380 N3881LDarnell David M · Bon Aqua, TNS/N 17254050 N3881SWynja Loreen Dee · Riverside, CABuilt 1963 · S/N 17251081 N3882QRiddle Kenneth G · Cherryville, NCBuilt 1971 · S/N 17259982 N3882SNichols Troy · Clinton, ARBuilt 1963 · S/N 17251082 N3883LBragg Gary W · Rainelle, WVBuilt 1966 · S/N 17254052 N3883QAir Williams LLC · Arlington, TXBuilt 1971 · S/N 17259983 N3883RGingras Carl A · Avondale, COBuilt 1966 · S/N 17255383 N3883SBruns Scott A · Brodhead, WIBuilt 1964 · S/N 17251083 N3884LCosta Jason L · Spring Hill, FLBuilt 1966 · S/N 17254053 N3884QWrangell Mountain Air Inc · Palmer, AKBuilt 1971 · S/N 17259984 N3884SHawley Michael C · Hampton, NHBuilt 1963 · S/N 17251084 N3885SLewis Kyle P · Shelbyville, KYBuilt 1964 · S/N 17251085 N3886LRench Eugene G · Owosso, MIS/N 17254055 N3887LHigley Ryan · Arlee, MTBuilt 1965 · S/N 17254056 N3888RGriswold Zachary S · Waunakee, WIBuilt 1966 · S/N 17255388 N3889LBaker Duane · Shepherd, TXS/N 17254058 N3889QRegistration Pending · White, GARegistration pendingBuilt 1971 · S/N 17259989 N3889RAdams Donald C · Garner, NCBuilt 1966 · S/N 17255389 N388JFAspire Aviation LLC · Farmingdale, NYS/N 17276182 N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525 N388TCDopson Joel A · Ooltewah, TNBuilt 1956 · S/N 29601 N3890LTexas Yellow Rose Planes LLC · Fort Worth, TXBuilt 1965 · S/N 17254059 N3890RWright Chad · Fredericktown, OHBuilt 1966 · S/N 17255390

Back to AD 90-06-03 R1