Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N7567KCutler Jeffrey R · Columbus, INBuilt 1979 · S/N P21000411 N7567QJolley Joseph J · Anchorage, AKBuilt 1978 · S/N U20604275 N7568270 North LLC · Anchorage, AKBuilt 1980 · S/N 20700638 N7568HEnergy Transfer Aviation LLC · Spring, TXS/N 18267917 N7568MPeters William R · Naperville, ILBuilt 1977 · S/N 21062021 N7568SAero Plus LLC · Thermopolis, WYBuilt 1976 · S/N 18265217 N7568TSale Reported · Phoenix, AZSale reportedBuilt 1977 · S/N R18200039 N7568VPawlish Andrew M · Fort Collins, COBuilt 1976 · S/N 177RG0859 N7568XKrassovsky Viatcheslav · Berkeley, CABuilt 1960 · S/N 17248068 N7568YAviation Associates LLC · Oxford, MDBuilt 1977 · S/N R18200137 N7569GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259269 N7569NArctic Aviation Leasing LLC · Anchorage, AKBuilt 1977 · S/N U20603679 N7569SEnginaires Aero Club Inc · Savoy, ILBuilt 1976 · S/N 18265218 N7569THuddleston Garry W · Brownstown, MIBuilt 1959 · S/N 47169 N7569VLiberty Capital LLC · Kalispell, MTBuilt 1976 · S/N 177RG0860 N756AHKincaid Linda C · North Pole, AKBuilt 1977 · S/N U20603932 N756ALLange Robert Brandt · Newport Beach, CABuilt 1979 · S/N R18201023 N756ANJelinek Tyson · Iola, KSBuilt 1977 · S/N U20603937 N756ARTehama Angus Ranch Inc · Gerber, CAS/N R18201024 N756AVSmith Air LLC · Cascade, IDBuilt 1977 · S/N U20603944 N756AWLincoln Skyways Inc · Lincoln, CABuilt 1976 · S/N 17267877 N756BBCampbell Steven P · Annapolis, CABuilt 1977 · S/N U20603950 N756BCBuchanan Bryan DBA · Gig Harbor, WABuilt 1979 · S/N R18201028 N756BNBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1977 · S/N U20603961 N756BYW Yerxa LLC · Colusa, CAS/N U20603971 N756CCBrown Travis J · Lincoln, ALS/N R18201035 N756CKMckee Jay Russell · Baggs, WYBuilt 1979 · S/N R18201038 N756CLEgli Sam · King Salmon, AKBuilt 1977 · S/N U20603983 N756CRConnell Donna M · Belton, TXBuilt 1977 · S/N U20603988 N756CTKamlowsky Scott A · Anchorage, AKBuilt 1977 · S/N U20603990 N756CXCahill Brian H · Valley Center, CABuilt 1979 · S/N R18201042 N756CZRegistered aircraftBuilt 1979 · S/N R18201043 N756DHDorothy M Walker Family Lp · Idaho Falls, IDBuilt 1977 · S/N U20604004 N756DJSutton Aircraft Salvage LLC · Palmer, AKS/N U20604005 N756DKMeyer David A · Torrance, CABuilt 1977 · S/N U20604006 N756DLSierra Sky Aviation LLC · Kalispell, MTBuilt 1977 · S/N U20604007 N756DNSkyler Aviation Inc · San Diego, CABuilt 1977 · S/N U20604009 N756DQBurgett Judson B · Fowler, INBuilt 1977 · S/N U20604011 N756DUCordova Air Service Inc · Cordova, AKS/N U20604015 N756DWManos Con Alas Aviation · Stateline, NVBuilt 1977 · S/N U20604017 N756EBTak Holdings LLC · Pleasant View, TNBuilt 1979 · S/N R18201046 N756EFTim Daniels Inc · Labelle, FLBuilt 1979 · S/N R18201048 N756EJPacker Louis M · Wasilla, AKS/N U20604029 N756EMPacific Aircraft Management LLC · Tacoma, WABuilt 1979 · S/N R18201052 N756ENU206 Sky LLC · Pompano Beach, FLBuilt 1977 · S/N U20604033 N756ETF&W Construction Co Inc · Anchorage, AKBuilt 1969 · S/N 185-1477 N756EUFisher Air LLC · Cardington, OHBuilt 1979 · S/N R18201055 N756EVOyarzo Benjamin C · Cascade, IDBuilt 1979 · S/N R18201056 N756EYHeartland Aviation Inc · Alliance, NES/N U20604043 N756EZBear Branch Hedeen LLC · Meridian, IDBuilt 1979 · S/N R18201058

Back to AD 87-20-03 R2