Skip to content

Registered aircraft · 20,687

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.

N8170BMelechin David H · Los Angeles, CAS/N 29970 N8170UFields William B · Climax, NCBuilt 1964 · S/N 17252070 N8170XWhittington Melinda Sara Secrest · Columbus, OHBuilt 1961 · S/N 17248670 N8171BByker Robert L · Porterville, CABuilt 1957 · S/N 29971 N8171LSam Aviation LLC · Long Beach, CAS/N 17256371 N8172UPrice Paul S · Camano Island, WABuilt 1964 · S/N 17252072 N8172XVital Twyla J · Seguin, TXBuilt 1961 · S/N 17248672 N8173BBetter Air Service LLC · Dailey, WVBuilt 1957 · S/N 29973 N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147 N8174BSmith Michael D · King George, VABuilt 1957 · S/N 29974 N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574 N8174UJenson James H · Downers Grove, ILBuilt 1964 · S/N 17252074 N8175BSmith Philip M · Houston, TXBuilt 1957 · S/N 29975 N8175UN8175u LLC · Rosemount, MNS/N 17252075 N8175XBeebe Shawn D · Ammon, IDBuilt 1961 · S/N 17248675 N8176LAdams David F · South Lyon, MIBuilt 1967 · S/N 17256376 N8176XCorrigan Walter E Jr · Seward, AKBuilt 1961 · S/N 17248676 N81772American Patrols Inc · Midland, TXS/N 17263860 N81775Flying B Aviation LLC · Waynesboro, TNBuilt 1967 · S/N 17255171 N8177LDenton Scotchie M · Calhoun City, MSS/N 17256377 N8177XUnderground Aviation Group LLC · Elizabethtown, PABuilt 1961 · S/N 17248677 N8178LMalone Traci L M · Effingham, ILBuilt 1967 · S/N 17256378 N8178XPaulsen Olaf · Clackamas, ORBuilt 1961 · S/N 17248678 N8179BWolford Robert C · Knoxville, TNBuilt 1957 · S/N 29979 N8179LExecutive Wings LLC · Bolivar, TNBuilt 1967 · S/N 17256379 N817EPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13592 N817FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13457 N817HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280828 N817PSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 17252705 N817TStone Michael A · Winston Salem, NCS/N 17250644 N817ZBennett Condon P · Stormville, NYBuilt 1976 · S/N 17266787 N8180BNiehaus James O · Erie, COBuilt 1957 · S/N 29980 N8180LManser Andrew R · Neenah, WIBuilt 1967 · S/N 17256380 N8180MLeap Aviation Inc · Wilmington, DES/N 17260570 N8181BManning Richard F Jr · Midway, GABuilt 1957 · S/N 29981 N8181UMillman Chris · Auburn, WABuilt 1964 · S/N 17252081 N8182ERed Arrow Aviation LLC · Santa Teresa, NMBuilt 1978 · S/N 17272148 N8182UMorristown Flying Service Inc · Talbott, TNBuilt 1964 · S/N 17252082 N8183UMacauley Richard D · Shingle Springs, CABuilt 1964 · S/N 17252083 N8184BPalouse Aviation Holdings LLC · Moscow, IDBuilt 1957 · S/N 29984 N8184GAspire Aviation LLC · Farmingdale, NYBuilt 1979 · S/N 17273615 N8184LVanderlaan Dirk C · Reno, NVBuilt 1967 · S/N 17256384 N8186BMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1957 · S/N 29986 N8186LBolsover Douglas J Sr · Cameron Park, CAS/N 17256386 N8186ULake Area Technical College · Watertown, SDBuilt 1964 · S/N 17252086 N8187BWithers Hurchel W · Stone Mountain, GABuilt 1957 · S/N 29987 N8189XQuire Gregory L Sr · Shepherdsville, KYBuilt 1961 · S/N 17248689 N818EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2018 · S/N 172S12165 N818EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12792 N818SPN818xp LLC · Charleston, SCBuilt 2001 · S/N 172S8734

Back to AD 90-06-03 R1