Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N447MHKelsey Terry D · Guthrie, TXFirst renewal noticeBuilt 2006 · S/N 11193 N447PJones Thomas C · Friendswood, TXS/N 108 N447RCEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 0205 N447RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020197 N447SCN447sc LLC · Carmel, CABuilt 1989 · S/N 4622074 N447TThompson Systems Inc · Amana, IABuilt 1969 · S/N 27-4288 N447TCOrange Sky LLC · Naples, FLS/N 006 N447VMiller Dustin · Visalia, CABuilt 2016 · S/N 40447 N447WPWall Cameron J · Enid, OKBuilt 2002 · S/N 5701 N44800Schoppe Marc · Durham, NCBuilt 1975 · S/N 28-7505012 N44802Page Aviation Services LLC · Fort Myers, FLS/N 28R-7535009 N44805Gage Christopher · Truckee, CABuilt 1974 · S/N 28-7525008 N44806Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 28-7515037 N4480JGonzalez Guadalupe G · Atwater, CABuilt 1967 · S/N 28-22896 N4480RSoutheastern Minnesota Flying Club Inc · Rochester, MNBuilt 1974 · S/N 17263222 N4480SCook Christopher R · Manhattan, KSFirst renewal noticeBuilt 1992 · S/N RV4120951SS N4480TSell Justin L · Lucerne, INBuilt 1972 · S/N 28R-7235067 N44813Olusanya Babajide A · Cherry Hill, NJBuilt 1974 · S/N 32-7540006 N44817Tokach Nicholas J · Hinckley, OHBuilt 1974 · S/N 28-7525009 N4481JMusser Fred R · Severna Park, MDFirst renewal noticeBuilt 1967 · S/N 28-22898 N4481TValdes Eusebio · Miami, FLS/N 34-7250108 N4481XSpence Johnn · Apache Junction, AZS/N 28-7625042 N4481ZTucker Jason M · Wasilla, AKBuilt 1969 · S/N 18-8816 N44820Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816022 N4482EStaton Stephen D · Soldotna, AKBuilt 1981 · S/N 18-8109025 N4482JWebe Properties LLC · Toledo, OHBuilt 1967 · S/N 28-22899 N4482RBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263224 N4482TIdeal Aviation LLC · Auburn, PABuilt 1972 · S/N 28-7205169 N4482YMiller Andy D · Marana, AZS/N 25-4140 N44836Monadnock Aviation Inc · Keene, NHBuilt 1977 · S/N 28-7816025 N4483CRich Aden Gene · Sequim, WABuilt 1959 · S/N 24-1257 N4483JHelms Tate · Lake Charles, LABuilt 1967 · S/N 28-22900 N4483TWaterboy Aviation LLC · Richlandtown, PABuilt 1972 · S/N 32-7240072 N4483XBowers Gregory L · Greensboro, NCBuilt 1975 · S/N 28-7690020 N4483ZWild Valley LLC · Wasilla, AKBuilt 1969 · S/N 18-8837 N44847Hill David F · Pembroke, MABuilt 1977 · S/N 28-7816026 N4484XDelta Charlie Aviation LLC · Royal Palm Beach, FLBuilt 1975 · S/N 28R-7635056 N4484YMasterwings LLC · Princeton, KYBuilt 1966 · S/N 25-4144 N44851King Air Inc · Naknek, AKS/N 32-7740107 N44855Marshall Xavier T · Carson, CAS/N 28-7816028 N44858Swaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7816032 N4485ACrabb Philip E · Fairbanks, AKBuilt 1956 · S/N 18-4850 N4485FSaunders Raymond C III · Albuquerque, NMBuilt 1976 · S/N 28-7790033 N4485HFrancesco Grasso · Lutherville, MDBuilt 1978 · S/N 24-0746 N4485TKreigh Kevin M · Auburn, INBuilt 1972 · S/N 28-7225161 N4485XL & A Bennett Second Family Lp · Renton, WAS/N 32-7640026 N44863Jg Aviation LLC · Indianapolis, INBuilt 1977 · S/N 32R-7780544 N4486FRegistration Pending · Hague, VARegistration pendingBuilt 1976 · S/N 28R-7635411 N4486HJennings Sabina · Carson, CABuilt 1978 · S/N 24-0747 N4486JHess Garrett J · Fullerton, CABuilt 1967 · S/N 28-22904

Back to AD 87-10-06 R1