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.

N32189Long Todd A · Maple Plain, MNBuilt 1974 · S/N 28-7515090 N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918 N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518 N32191Czyszczon Aviation LLC · St Pete Beach, FLS/N 28-7515092 N32192White Charles J · Spring Lake, MIBuilt 1974 · S/N 28-7515093 N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036 N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034 N32197Brunzlick Larry R · Chuckey, TNBuilt 1974 · S/N 32-7540022 N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035 N3219FTop Flight Detail LLC · Middlebury, INS/N 670012 N3219GWest Mi Shooting Alliance For Excellence Sfty LLC · Marne, MIBuilt 1976 · S/N 18-7709030 N3219PShoot LLC · River Ridge, LAS/N 14243 N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132 N321ABAmbrosini Alfred F · Connellsville, PABuilt 1979 · S/N 14523 N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N321AMGuerin Michael L · Torrington, WYBuilt 1975 · S/N 75-31117 N321ASAirtravel LLC · Reno, NVBuilt 1976 · S/N 61P-0358-111 N321BCGeorge Nathan V · Dardanelle, ARS/N 370-95 N321BHKinkel Philip J · Bow, WAS/N 5138 N321BYStates Thane · Boise, IDBuilt 2008 · S/N 40337 N321BZJakes Air Service LLC · Holt, FLBuilt 1999 · S/N 22968 N321CGSuper 700 LLC · Robbinsville, NJBuilt 1979 · S/N 61P07097963341 N321CKFairwinds Aviation LLC · Goldsboro, NCBuilt 2004 · S/N 40.414 N321CUStambaugh Scot D · Bainbridge Island, WABuilt 2004 · S/N 019 N321DKTwi Air LLC · Picayune, MSBuilt 1998 · S/N 18280311 N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236 N321DPDelta Papa LLC · Henderson, NVBuilt 1979 · S/N 32-7940032 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321EFRengel Richard J · Tustin, CAS/N 1900 N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729 N321FSUtah State University · Logan, UTBuilt 2004 · S/N 40.384 N321GBTwisted Roots Aviation LLC · Chesterton, INBuilt 1964 · S/N 28-10413 N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461 N321GTBennett Craig · Newbury Park, CABuilt 1994 · S/N 21158 N321GW321gw LLC · Chico, CABuilt 1998 · S/N 18280209 N321HPNfas LLC · League City, TXBuilt 1974 · S/N 32-7440099 N321HWVan Andel Lambert J Jr · Coopersville, MIBuilt 1998 · S/N 18280264 N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560 N321JECapital Affairs West LLC · Helena, MTBuilt 2004 · S/N 40.374 N321KAMid Valley Air LLC · Jessup, PABuilt 2000 · S/N 3257142 N321KJFly-By LLC · Cope, COBuilt 2022 · S/N 12190081 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321LALowair LLC · Lake City, SCBuilt 1978 · S/N 32R-7885178 N321LMStarkey Mike · Dayton, NVBuilt 2021 · S/N 12180029 N321MAKnox Props Aviation LLC · Cookeville, TNBuilt 2002 · S/N 3257311 N321MCAerospace Trust Management LLC Trustee · Wilmington, DES/N 5233 N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850 N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084 N321NASanchez David A · San Luis Obispo, CABuilt 2001 · S/N 24650

Back to AD 87-10-06 R1