Skip to content

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.

N322PMMsr Aviation LLC · San Diego, CABuilt 2005 · S/N 29-0365 N322RMPhillips George Thomas · Carson City, NVBuilt 1981 · S/N 414A0827 N322RWKraemer Jeremy A · Melrose, MNBuilt 2000 · S/N 29-0218 N322SACimarron LLC · Kurten, TXBuilt 1985 · S/N TH-1488 N322SPBurkett Gary L Trustee · Murfreesboro, TNBuilt 1968 · S/N TE-531 N322TWRegistration Pending · Fairview, NCRegistration pending, pending cancellationBuilt 2002 · S/N 0312 N322WAAlderman & Company Wings LLC · Danbury, CTBuilt 2004 · S/N 0811 N3230RAkradi Parviz · Irvine, CABuilt 1987 · S/N CE-1173 N3232WKilgallen Keith S · Stuart, FLBuilt 1995 · S/N E-2932 N32331Sowers Richard M · Reno, NVBuilt 1980 · S/N 21064188 N3233GMach Aviation Pilot Services LLC · Andover, KSBuilt 1995 · S/N E-2933 N3233JZebcon Inc · Russellville, ARBuilt 1999 · S/N E3233 N3233LMann Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA633 N3235DMdb Ventures LLC · Wausau, WIBuilt 1995 · S/N E-2935 N3235TBhatia Kabir · Lake Oswego, ORBuilt 1995 · S/N EA-577 N3236QBo'S Investments LLC · Amarillo, TXBuilt 1997 · S/N E3110 N3236THg Aviation LLC · Helena, MTBuilt 1995 · S/N E-2936 N3236ZJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1991 · S/N EA-526 N3238YKorff Aviation LLC · Leesburg, VABuilt 1995 · S/N E-2938 N3239Q92nd West Aviation Inc · Lonoke, ARBuilt 1967 · S/N 401-0039 N3239WHaidlen Ford Inc · Oakdale, CABuilt 1995 · S/N E-2939 N323CD2 Guys Aviation LLC · Okeechobee, FLBuilt 2004 · S/N 1020 N323CLHoge John · Setauket, NYBuilt 2002 · S/N 40054 N323DASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064753 N323DCFlymax Aircraft LLC · Ball Ground, GAS/N P21000384 N323DMWard Frank J · N Richland Hills, TXBuilt 1998 · S/N 29-0155 N323FLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1985 · S/N 468508096 N323GBGs Aviation LLC · Lebanon, TNBuilt 1975 · S/N E-647 N323JLLeghorn Airfleet LLC · Columbus, INBuilt 1968 · S/N TE-608 N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667 N323PMSrc Property LLC · Alpine, TXS/N EA-161 N323RCTigers Aviation LLC · Wasilla, AKBuilt 1980 · S/N EA-87 N323TJGuardian Wings LLC · Fredericksburg, VABuilt 1983 · S/N T30300243 N323UShaneyfelt Samuel J · Shady Shores, TXBuilt 1966 · S/N D-8029 N323WWhitewings Aviation LLC · Milton, GABuilt 2005 · S/N 1509 N3240NAir Services Of Mississippi Inc · Mccomb, MSBuilt 1995 · S/N E-2980 N3243BKcirro LLC · Portland, ORBuilt 1999 · S/N E-3243 N3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CABuilt 1995 · S/N EA-575 N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746 N3246RRegistered aircraftBuilt 1995 · S/N E-2946 N3247PCary Leasing & Management LLC · Boerne, TXBuilt 1999 · S/N EA-647 N3247XExcalibur Aviation LLC · Spencer, IABuilt 2000 · S/N E-3347 N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748 N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948 N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949 N3249JSelge Leasing Inc · Niles, MIS/N E-3349 N324BHN324bh LLC · Roanoke, VABuilt 2025 · S/N E-4162 N324DBush David M · Englewood, COBuilt 1965 · S/N D-8016 N324EAWaytack LLC · Bryant, ARBuilt 2015 · S/N TH-2452 N324GT324 Aviation LLC · Cavour, SDBuilt 1979 · S/N EA-38

Back to AD 86-13-04 R3