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.

N3534QLeatherneck Aviation LLC · Billings, MTBuilt 1969 · S/N 188-0484 N353CDSt Croix Leasing LLC · Fredonia, WIBuilt 2004 · S/N 1210 N353EEBruce Douglas E · Desmet, IDBuilt 1976 · S/N 18503150 N353PGDecarlo Rick P · Minden, NVBuilt 2004 · S/N 1115 N353RSecond Time Around Lt LLC · Corona, CAS/N D-10209 N3540MDybel William P · Frankfort, ILS/N 421B0472 N35443Registered aircraftBuilt 1973 · S/N 21059992 N35498Ray Arthur G · Springdale, ARBuilt 1973 · S/N 21059996 N354BCChamberlain Donald H · Ooltewah, TNBuilt 1989 · S/N E-2485 N354BWCarpenter Richard A · Hermiston, ORBuilt 1979 · S/N EA-40 N354DAir Repair Inc · Deadwood, SDBuilt 1964 · S/N D-7659 N354DJN354dj LLC · Gulfport, MSBuilt 1980 · S/N D-10326 N354DPShaffer John · Virginia Beach, VABuilt 1966 · S/N D-8309 N354DRRadwanski D · Westmont, ILBuilt 1978 · S/N D-10102 N354DZDachnowicz Peter A · Avon, CTBuilt 1972 · S/N D-9336 N354JMountain V-Tail LLC · Denver, COS/N D-7857 N354KPTri County Flying Club Llp · Estelline, SDBuilt 1964 · S/N D-7612 N354LCDelos Anesthesia Services Pc · Barstow, CABuilt 1966 · S/N D-8161 N354MMission Aviation LLC · Billings, MTBuilt 1964 · S/N D-7516 N354PFBillen Jerome · Hodges, SCBuilt 1972 · S/N D-9313 N3558FPacific Rim Adventures Inc · Los Olivos, CAS/N 185-1438 N355DCRyan John T · Salina, KSBuilt 1984 · S/N 46-8408079 N355DJVerdoljak Corey A · Homer, AKBuilt 1977 · S/N 18502954 N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633 N355SAReddy James N Trustee · Port Orange, FLBuilt 2000 · S/N E-3357 N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795 N355TAIsland Amphibs LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1976 · S/N U20603446 N355WBWhite River Aviation LLC · Midway, ARBuilt 1966 · S/N TE-287 N355YPlussa Mark George · Clermont, FLBuilt 1980 · S/N 21064137 N3561QSales Joe H · Seminole, TXBuilt 1969 · S/N 188-0511 N3565JKendrick Ross Mitchell · Sycamore, GABuilt 1980 · S/N T18803651T N3566WGriffin Aviation LLC · Minneapolis, MNBuilt 1999 · S/N TH-1930 N35677C3 Indutries LLC · Bakersfield, CABuilt 1973 · S/N 21060007 N356WBMwm Interests Inc · The Woodlands, TXBuilt 2009 · S/N 261 N357AFour Leaf Air LLC · Cedar, MIBuilt 2003 · S/N 29-0311 N357CEWindh Steven R · Reedley, CABuilt 1962 · S/N 271 N357CSN357c5 LLC · Clinton, MOBuilt 1984 · S/N 46-8508026 N357DRegis Frederic · Denver, COBuilt 1967 · S/N D-8562 N357JTClub Bo A36 LLC · Helena, MTBuilt 1979 · S/N EA-51 N357LCSkywagon Ventures LLC · Anchorage, AKBuilt 1981 · S/N 18504295 N357MMClark Melvin G · Sunnyvale, TXBuilt 1985 · S/N 46-8508092 N357SHill V35 LLC · Nashville, TNBuilt 1967 · S/N D-8679 N357VSavoy Harolde M Trustee · Dallas, TXBuilt 2004 · S/N L2K-186 N35806Air Dakota Flite Inc · Hettinger, NDBuilt 1973 · S/N 21060011 N35837Smernoff Michael J · Des Plaines, ILBuilt 1975 · S/N U20602749 N35851Northwest Passage LLC · Anchorage, AKS/N U20602757 N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763 N35868Spence Flight Service LLC · Enterprise, ORBuilt 1973 · S/N U20602107 N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777 N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779

Back to AD 86-13-04 R3