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.

N53351Clover Park Technical College · Lakewood, WABuilt 1981 · S/N 17274725 N53352Fat Boy Air Sales & Leasing LLC · Naples, FLS/N 172S9352 N5335DPeltz Matthew J · Ringsted, IABuilt 1979 · S/N 17272524 N5335GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281158 N5335JFirst Eclipse Limited · Richmond, VABuilt 2003 · S/N 172S9347 N5335SSpartan Education LLC · Tulsa, OKBuilt 2003 · S/N 172S9349 N53361Adb Aircraft LLC · Viera, FLBuilt 1981 · S/N 17274727 N5336DFerguson Bart M · Argyle, TXBuilt 1979 · S/N 17272525 N5336KSharpes Daniel G · Albuquerque, NMBuilt 1980 · S/N 17274069 N53371Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274733 N53372Clover Park Technical College · Lakewood, WABuilt 2003 · S/N 17281170 N53373Bemidji Aviation Services Inc · Bemidji, MNS/N 17274734 N53387Reifsnyder Daniel S · Lewistown, PABuilt 1981 · S/N 17274738 N5338NRaritan Valley Flying School · Princeton, NJBuilt 2003 · S/N 172S9358 N5338TKidd Cody M · Martinsville, OHS/N 17251238 N5338VMassie Patrick J · Friendswood, TXBuilt 1980 · S/N 172RG0509 N5339DTang Hong-Ming · San Dimas, CABuilt 1979 · S/N 17272528 N5339HBering Capital LLC · Anchorage, AKBuilt 1975 · S/N 17265407 N5339KNordell Kent D · Staples, MNBuilt 1980 · S/N 17274071 N5339MM&M Management Group LLC · Englewood, COBuilt 2003 · S/N 172S9359 N533BMGray Ronald P · Glendale, AZBuilt 1999 · S/N 172S8340 N533KSKent State University · Stow, OHBuilt 2012 · S/N 172S11240 N533SJLns LLC · Wichita, KSBuilt 1978 · S/N 17271533 N53402Anvab Inc DBA · Concord, NHBuilt 1981 · S/N 17274743 N5340TRundell Lanny · Winnsboro, LABuilt 1964 · S/N 17251240 N53417Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 17281162 N5341HHoffman Calhoun E · Barnwell, SCBuilt 1975 · S/N 17265408 N5342DCornell Timothy R · Hartland, WIS/N 17272531 N5342QBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281153 N5342TLima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9360 N5342YAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9361 N53437Vineyard Eddie E · Wapello, IABuilt 1981 · S/N 17274749 N5343RMcmahon Michael E · Porterfield, WIBuilt 1965 · S/N 17252871 N53440Air Spacers Inc · Santa Monica, CABuilt 2003 · S/N 172S9365 N5344DAirgo Inc · Centralia, ILBuilt 1979 · S/N 17272532 N5344FWingsleasing LLC · Wichita, KSS/N 172S9363 N5344HA&F Aviation Services LLC · Collierville, TNBuilt 1975 · S/N 17265409 N5344KBoeing Employees Flying Assoc · Renton, WABuilt 1980 · S/N 17274074 N5344RMoxley Michael D · Spearfish, SDBuilt 1965 · S/N 17252872 N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754 N5345TBerrong Jimmy L Sr · Dahlonega, GABuilt 1964 · S/N 17251245 N53460L & W Leasing LLC · Smyrna, TNBuilt 2003 · S/N 172S9351 N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758 N53468Maya Aircraft Holdings LLC · Lee, NHBuilt 2003 · S/N 172S9394 N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534 N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573 N5346KUsaeroflight LLC · Greenville, SCS/N 17274075 N5346TTiffany Shawn M · Herington, KSBuilt 1964 · S/N 17251246 N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510 N53474Executive Air Taxi Corp · Bismarck, NDBuilt 2003 · S/N 172S9376

Back to AD 90-06-03 R1