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.

N3289FRubiales Mauricio A Jr · San Diego, CABuilt 1967 · S/N 670382 N3289QTrident Aircraft Leasing LLC · Easton, MDBuilt 1977 · S/N 28-7716146 N3289WShandon Aviation LLC · Lewes, DES/N 32-122 N328CTRegistration Pending · Middleton, NHRegistration pendingBuilt 2003 · S/N 432 N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401 N328DHBrown Kevin E · Rosamond, CABuilt 2004 · S/N BV001 N328ESisson J P · Litchfield, ILBuilt 2004 · S/N 20762 N328GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881115 N328HPAlan C Perry LLC · Lake Charles, LABuilt 2000 · S/N 3257166 N328JMGrand Aviation Inc · Grove, OKS/N 2082 N328MDJames Douglas M Trustee · Scottsdale, AZBuilt 1995 · S/N 758-95 N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575 N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164 N328SGUp Lights LLC · Jacksonville, FLBuilt 2013 · S/N 1 N328SSUnited Helicopter Leasing LLC · Honolulu, HIBuilt 2002 · S/N 1214 N328TRRufi Craig · Thousand Oaks, CABuilt 2019 · S/N 40555 N32903Foxtail Aviation LLC · Orefield, PABuilt 1974 · S/N 28-7515271 N32904Sheidler Randy L · Gallipolis, OHBuilt 1974 · S/N 28-7515272 N32906Benson Brian R · Mauston, WIBuilt 1974 · S/N 28-7515273 N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147 N32919Mbap LLC · Salt Lake City, UTS/N 32-7540074 N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493 N3291FEvans Derek M · Fresno, CABuilt 1967 · S/N 670384 N3292FGoodwin Darrell W · Richmond, TXBuilt 1967 · S/N 670385 N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292WOldenkamp Daryl · Hermosa Beach, CAS/N 32-125 N3292ZAlbertson James M · Westville, FLBuilt 1959 · S/N 18-7229 N32932Gilbert Roy S · Mechanicsville, VABuilt 1974 · S/N 28-7515276 N32934Robert Craig LLC · Wilmington, DEBuilt 1975 · S/N 32-7540075 N3293BHuttunen Alice D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3287 N3293FYe Xiaofeng · Los Gatos, CABuilt 1968 · S/N 680001 N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447 N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264 N3293VMckinney Brian · Lakeville, MNBuilt 1995 · S/N 80 N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230 N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231 N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279 N3294CNorwood Kent L · Springfield, MOBuilt 2015 · S/N 90649 N3294FWatkins Grant M · Durant, OKBuilt 1967 · S/N 670387 N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N32956Meritt Kendall E · Wayne City, ILBuilt 1974 · S/N 28-7510035 N3295WChapman Daniel H Jr · Ontario, CABuilt 1965 · S/N 32-128 N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282 N3296BCommand-Aire LLC · Coatesville, PABuilt 2000 · S/N 14673 N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106 N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103 N3297FCadillac Aircraft Services Inc · Cadillac, MIBuilt 1967 · S/N 670390 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597

Back to AD 87-10-06 R1