Registered aircraft · 72,007

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.

N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101 N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321PFRrsf LLC · Pleasant Grove, UTBuilt 2004 · S/N 40.375 N321PKYaqunda Yousif N · Fallbrook, CABuilt 1994 · S/N PK-1 N321PRChavi LLC · Fredericksburg, TXBuilt 2006 · S/N 11142 N321PWSquaw Valley Air Force LLC · Reno, NVS/N T18208171 N321QPelco Aviation Inc · Hampton Bays, NYBuilt 1978 · S/N R18200438 N321RCHitchen Robin J · Bernardsville, NJBuilt 2013 · S/N 90217 N321RJGritter Richard J · Catlett, VABuilt 1977 · S/N 323-77 N321RTBarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 189 N321RVRegistration Pending · Norton Shores, MIRegistration pendingBuilt 1998 · S/N 20372 N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N321SKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2019 · S/N 30050 N321SPWest Electrical Contractors Inc · Newberry, SCBuilt 1974 · S/N 32-7440119 N321SREstler Carlton George · Richmond, TXBuilt 1995 · S/N 3239 N321TAAldag Thomas D · Wichita, KSBuilt 2020 · S/N 83171 N321TCRice Justin M · Minot, NDBuilt 1990 · S/N 27-0038 N321TDDeakyne David J · Wallingford, PABuilt 1992 · S/N DEAKYNE 0001 N321TEBerg Orvie E Trustee · Rock Springs, WYBuilt 2001 · S/N 32 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N321VAvia Flight Academy LLC · Stratford, CTBuilt 1968 · S/N 28-4665 N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533 N321VESullivan Mike D · Braddyville, IABuilt 1995 · S/N DMO243 N321VTWinick Scott · Jay, VTBuilt 1973 · S/N 507 N321WFWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 17280987 N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327 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 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 N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163 N3223PPrestige Tech Consulting Inc · Carrollton, TXS/N 1181 N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541 N32245Johnson Donald D · Scottsdale, AZBuilt 1974 · S/N 28-7515102 N3224CHassebrock John M · Colorado Springs, COBuilt 1978 · S/N R18200257 N3224FShaffer Aviation LLC · Keystone Heights, FLBuilt 1967 · S/N 670017 N3224PEighttwotwo LLC · Wilmington, DEBuilt 2014 · S/N 73504 N3224WMedic Choppers LLC · Springdale, ARS/N 32-31 N3224ZBagley Sherell G · Suwanee, GABuilt 1959 · S/N 22-7168 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

Back to AD 87-10-06 R1