Skip to content

Registered aircraft · 22,413

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-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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.

N321KAMid Valley Air LLC · Jessup, PABuilt 2000 · S/N 3257142 N321LALowair LLC · Lake City, SCBuilt 1978 · S/N 32R-7885178 N321MAKnox Props Aviation LLC · Cookeville, TNBuilt 2002 · S/N 3257311 N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N321SPWest Electrical Contractors Inc · Newberry, SCBuilt 1974 · S/N 32-7440119 N321VAvia Flight Academy LLC · Stratford, CTBuilt 1968 · S/N 28-4665 N321YHAig Aeronautics LLC · Guaynabo, PRBuilt 2005 · S/N 3257386 N321YZStroh Michael · Killdeer, NDS/N 28-7505039 N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036 N32204Flying Country Club Inc · Coal Valley, ILBuilt 1974 · S/N 28-7515094 N32205Glidewell Frank Armond Jr · Auburn, ALS/N 28-7515095 N32206Williams Jonathan · Meadow, TXBuilt 1974 · S/N 28-7515097 N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037 N3220WBarnes Matthew Thomas · Valdosta, GABuilt 1965 · S/N 32-25 N3221WRay Troy D · Roanoke, VAFirst renewal noticeBuilt 1965 · S/N 32-27 N32223Boehm William Dean · Baldwin, ILS/N 28-7515101 N32228Segalla Susan B Trustee · Venice, FLBuilt 1974 · S/N 28-7505040 N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541 N3223WWaynen Michael C · Runaway Bay, TXS/N 32-30 N32245Johnson Donald D · Scottsdale, AZBuilt 1974 · S/N 28-7515102 N3224WMedic Choppers LLC · Springdale, ARS/N 32-31 N32251Kful Flyers Foudation Inc · Fullerton, CAS/N 28-7515104 N32255Registered aircraftBuilt 1974 · S/N 28-7505041 N32256Hasek Christopher A · Plano, TXBuilt 1974 · S/N 28-7505042 N32258Wing Rentals LLC · Phoenix, AZBuilt 1974 · S/N 28-7505043 N3225RHansen Duane D · Rockford, ILBuilt 1969 · S/N 28R-31134 N3225WCherokee Aero Group Inc · Lakeland, FLBuilt 1965 · S/N 32-33 N32265Norsesian Brandon · Valrico, FLBuilt 1974 · S/N 28-7525040 N32267Top Flight Aviation LLC · Reedsburg, WIBuilt 1974 · S/N 28-7515105 N32269Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7515106 N3226WAlbert James R · Corpus Christi, TXBuilt 1965 · S/N 32-34 N32271Tylka Edward · Lockport, ILBuilt 1974 · S/N 28-7505044 N32274Simaan Daniel · Fontana, CABuilt 1974 · S/N 28-7525042 N32276Price Company · Spokane, WABuilt 1974 · S/N 28-7515109 N3227QBrands Robert C · Cary, NCS/N 32R-7780299 N32288Habzansky Michael E · Greens Fork, INBuilt 1974 · S/N 287515112 N3228QR&G Aviation LLC · Jonesboro, ARS/N 32R-7780300 N32291Active Pilot Inc · Van Nuys, CABuilt 1974 · S/N 28-7515114 N32292Mdr Rental Corp · Ann Arbor, MIBuilt 1974 · S/N 28-7515115 N32293Stone James B · Springfield, VABuilt 1974 · S/N 28-7505046 N32294Cloud Dancer Aviation Inc · Deland, FLBuilt 1974 · S/N 28R-7535041 N32296Fly South Aviation LLC · Charlotte, NCBuilt 1974 · S/N 28-7525046 N32299Lundahl Kristina N · Windsor, COBuilt 1974 · S/N 28-7515116 N322CARoyal Majesty Aviation LLC · Atlanta, GAS/N 28R-7130013 N322CCHall Robert · North Canton, OHS/N 32-7940117 N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545 N322EFRkm Aviation · Lexington, NCBuilt 2021 · S/N 28020031 N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096 N322NDUn Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881749

Back to AD 87-08-08 R3