Registered aircraft · 18,497

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.

N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540 N227LPLetourneau Plastics Inc · Oconto, WIBuilt 2015 · S/N E-4072 N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682 N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523 N227SSRiver Front Akn LLC · Anchorage, AKBuilt 1970 · S/N U20601516 N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344 N2280RRusso John · Seaside, CAS/N T210-0430 N2283LMoser Jerald L · Tucson, AZS/N D-9948 N2284LUpchurch David E · Bahama, NCBuilt 1976 · S/N E-929 N2285LN2285l Aviation LLC · Robbinsville, NJBuilt 1976 · S/N E-930 N2286LBaty John W · Ames, IABuilt 1976 · S/N CE-675 N2287RTail Winds To The Island Inc · Ashland, KYBuilt 1969 · S/N T210-0437 N2289BHollister Jet Center Inc · Hollister, CAS/N CE-178 N2289ERegistered aircraftBuilt 1997 · S/N TH-1821 N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949 N228ABLuke Stephen J Trustee · Middleboro, MABuilt 1991 · S/N E-2655 N228CCutter Southwest Aircraft Sales LLC · Phoenix, AZBuilt 1985 · S/N CE-1059 N228CENamrac Aviation LLC · Hazard, KYBuilt 2014 · S/N TH-2407 N228DMStone Michael · Payson, AZBuilt 1991 · S/N E-2660 N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006 N228MMFly Enterprises LLC · Cumberland, WIBuilt 2005 · S/N 1335 N228QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N D-8135 N228ZFFandrich Edward I · Payson, AZS/N 18502461 N2290SElco Avion LLC · Eagle Lake, TXBuilt 1976 · S/N 21061233 N2292LGenzoli Steven · Hughson, CABuilt 1976 · S/N D-9947 N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097 N2293JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803449T N2293LLemac Aviation LLC · Mesa, AZBuilt 1976 · S/N E-971 N2294LFlying Friends LLC · Shavano Park, TXBuilt 1976 · S/N CE-676 N2295ASemper Primus LLC · Las Vegas, NVBuilt 1969 · S/N D-9039 N2295RDuhl James R · Roseville, MNFirst renewal noticeBuilt 1969 · S/N T210-0445 N2295WBraswell Jerrold W · Dillingham, AKBuilt 1978 · S/N 20700448 N2296DBonanza Flyers L3c · Murray, UTBuilt 1977 · S/N D-9997 N2296LDel Air Inc · Wilmington, DEFirst renewal noticeBuilt 1976 · S/N E-932 N2296RCelias Food Corp · Miami, FLS/N T210-0446 N2296VGustafson Kim L · Lake Stevens, WABuilt 1968 · S/N TE-587 N2298EUberoy Pawan · Pleasanton, CABuilt 1997 · S/N E3138 N2299LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N CE-677 N2299RBaer Monte Wayne · Ronan, MTS/N T210-0449 N229ESLastowski Jeffrey A · Mooresville, INBuilt 1967 · S/N CE-174 N229QMike Lima Partners LLC · Wilmington, DEBuilt 1966 · S/N D-8169 N229RMMjt Real Estate Holdings LLC · Orlando, FLBuilt 2002 · S/N 0416 N229TTWcps Aviation LLC · Marietta, GABuilt 2010 · S/N E-3929 N22AGMavridoglou Theo A · Brandon, MSBuilt 1973 · S/N D-9499 N22AHMalchoff Keith B Jr · Yuma, COBuilt 1970 · S/N 30327 N22AMJays Aircraft Maintenance Inc · Costa Mesa, CABuilt 1979 · S/N 310R1634 N22AYRegistration Pending · Lebanon, PARegistration pendingBuilt 2004 · S/N 1176 N22BYDelton LLC · Pembroke Pines, FLBuilt 1964 · S/N D-7609 N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188 N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471

Back to AD 86-13-04 R3