Skip to content

Registered aircraft · 18,495

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N752VAN648ds LLC · Sag Harbor, NYBuilt 2017 · S/N E-4103 N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030 N7531QSantiago Jose G Jr · Woodstock, GABuilt 1969 · S/N 310Q0031 N7532NEagle Air LLC · Morgantown, WVBuilt 1977 · S/N U20603664 N7539NDavis Dale L · Boerne, TXBuilt 1977 · S/N U20603666 N753BDistefano John · Bayville, NJBuilt 1966 · S/N CE-75 N753DMAcid And Cementing Inc · Palestine, TXBuilt 2002 · S/N TH-2047 N7540NMadison Fasteners LLC · Hanover, INBuilt 1968 · S/N CE-234 N7542DBeach Bound Baron LLC · Modena, NYBuilt 1971 · S/N TE-843 N7542NHale Benjamin · Iowa City, IABuilt 1968 · S/N E-57 N7543NSteier Joseph E Trustee · Omaha, NES/N E-58 N7548NSorenson Mark E · Deaver, WYBuilt 1968 · S/N E-64 N7549NLauterbach Dennis R · Midlothian, TXBuilt 1968 · S/N E-66 N754HCLincoln Road Real Estate LLC · West Union, IAS/N E-3768 N754JSDy34 LLC · Adamsville, TNBuilt 1975 · S/N 414-0643 N754KCPlane Crazy Aviation LLC · Fargo, NDBuilt 1981 · S/N 414A0803 N754PMid Continent Harley Davidson Inc · Wichita, KSBuilt 1973 · S/N E-461 N7550NReynolds Stephen C · Bayview, TXBuilt 1968 · S/N E-67 N7555NSouth Delta Aviation Inc · West Helena, ARBuilt 1968 · S/N CE-197 N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604 N7558HAlaska Bear Safaris LLC · Homer, AKS/N 18503394 N755ACAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402A0001 N755APValiair Limited Company Trustee · Casper, WYBuilt 2016 · S/N TH-2470 N755CMelina Aviation Inc · Wilmington, DES/N 0392 N755CDCirus N755cd LLC · Aventura, FLBuilt 2001 · S/N 0121 N755CMCluster Fish LLC · Charleston, SCBuilt 1980 · S/N 21063934 N755GHJeff Hux Farms LLC · Sikeston, MOBuilt 1997 · S/N TH-1838 N755GSInfinitymail Corp · Pleasanton, CABuilt 2004 · S/N 0983 N755HBBrown William Henry · Ravenna, TXBuilt 1979 · S/N 18053018 N755RTired Iron Aviation LLC · Sheridan, WYBuilt 1980 · S/N EA-85 N755SWMelendez Daniel Alexan · Yuma, AZBuilt 1975 · S/N 21060965 N755XLandis David A · Perryton, TXBuilt 1967 · S/N D-8578 N7560HRio Brazos Aviation LLC · Waco, TXBuilt 1977 · S/N 18503396 N7561NPierce County Sheriffs Department · South Hill, WABuilt 1977 · S/N U20603673 N7562QKaihai Corp · Wilmington, DEBuilt 1978 · S/N 18503610 N7562USchuebel Douglas R · Cameron, WIBuilt 1978 · S/N 15077738 N7564HYukon Air Service Inc · Fairbanks, AKBuilt 1977 · S/N 18503397 N7565HWright Kim B · Anchorage, AKBuilt 1977 · S/N 18503398 N7567KCutler Jeffrey R · Columbus, INBuilt 1979 · S/N P21000411 N7567QJolley Joseph J · Anchorage, AKBuilt 1978 · S/N U20604275 N7568MPeters William R · Naperville, ILBuilt 1977 · S/N 21062021 N7569NArctic Aviation Leasing LLC · Anchorage, AKBuilt 1977 · S/N U20603679 N756AHKincaid Linda C · North Pole, AKBuilt 1977 · S/N U20603932 N756ANJelinek Tyson · Iola, KSBuilt 1977 · S/N U20603937 N756AVSmith Air LLC · Cascade, IDBuilt 1977 · S/N U20603944 N756BBCampbell Steven P · Annapolis, CABuilt 1977 · S/N U20603950 N756BNBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1977 · S/N U20603961 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

Back to AD 86-13-04 R3