Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N333UMUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1980 · S/N 15284751 N333VBHumes Garrett D · Leesburg, FLBuilt 1975 · S/N 15076623 N333VWHelderman Laban W · Newton, NCBuilt 1956 · S/N 33952 N333WGWilliams Samantha L · Kendallville, INS/N 15065465 N333YFEagle Aviation LLC · Delray Beach, FLBuilt 1978 · S/N R18200747 N333YTRegistered aircraftBuilt 1968 · S/N 18258912 N333ZVWalker Wilber D III · Beeville, TXBuilt 1977 · S/N 18265835 N3340JSteiner William Mark · Newport Beach, CABuilt 1966 · S/N 15066040 N3340RFrieze Rex · Fair Play, MOBuilt 1967 · S/N 18258640 N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140 N3340UGingerich Fred D · Heron, MTBuilt 1963 · S/N 18254740 N3340YMckinney Sandra C · Williamsburg, OHBuilt 1962 · S/N 18254340 N3341DTwenty One Miles LLC · Woodland Hills, CABuilt 1955 · S/N 32139 N3341FLani Lea Sky Tours LLC · Honolulu, HIBuilt 1966 · S/N 18257341 N3341RKozlenko Roman · Irvine, CABuilt 1967 · S/N 18258641 N3341TWatson Dennis R · Fort Worth, TXBuilt 1967 · S/N 17700641 N3341UKroschel Wayne Addie · Mora, MNBuilt 1963 · S/N 18254741 N3341VAreeckal Rejee · Mcallen, TXBuilt 1974 · S/N 15076467 N3342FKaradza Bosko S · Welch, MNS/N 18257342 N3342URobert Smith Associates Inc · Albany, NYBuilt 1963 · S/N 18254742 N3343FLutes Ralph E · Shipshewana, INBuilt 1966 · S/N 18257343 N3343JAndresen Paul S · Chandler, AZS/N 15066043 N3343TMcclellan Dabney B · Centerburg, OHBuilt 1967 · S/N 17700643 N3343VVitale Paul P · Green Valley, AZBuilt 1974 · S/N 15076468 N3344JSaitto Jeffrey M · Media, PAS/N 15066044 N3344RStorm Water Services Inc · Redmond, ORBuilt 1967 · S/N 18258644 N3344UPiescinski Kurt G · Fort Lauderdale, FLBuilt 1963 · S/N 18254744 N3345FBrassard Alan Gaston · Durham, NCBuilt 1966 · S/N 18257345 N3345RJennings Mamie M · Springfield, ILBuilt 1967 · S/N 18258645 N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145 N3345TJefts Donald R · Scotia, NYBuilt 1967 · S/N 17700645 N3346EEarnst Kelly S · West Lafayette, INBuilt 1978 · S/N 17271512 N3346LHarper Matthew Clay · Anchorage, AKS/N 185-1274 N3346RGonzalez Oscar · Bedford, TXBuilt 1968 · S/N 18258646 N3346YVantrease Jerold L · Homer, AKBuilt 1962 · S/N 18254346 N3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZBuilt 1966 · S/N 18257347 N3347LAcumen Aerotech LLC · Rogers, TXBuilt 1967 · S/N 185-1275 N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147 N3347YMccoy Mark B · Honea Path, SCBuilt 1962 · S/N 18254347 N3348UCollins Christopher E · Bluford, ILBuilt 1963 · S/N 18254748 N3348YBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254348 N3349CCabrera John F · Glendale, CABuilt 1978 · S/N R18200274 N3349DWeninger Gregory M · Burrton, KSBuilt 1955 · S/N 32147 N3349FMaxfield David · Greenville, SCBuilt 1966 · S/N 18257349 N3349JRegistration Pending · Quincy, OHRegistration pendingS/N T18803632T N3349SJin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276255 N334SCGist Sally R · Horseshoe Bay, TXBuilt 1960 · S/N 50691 N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331 N334YWarner Aric D · Rosamond, CAS/N 18051299 N33503Sueltenfuss Tyler G · Boerne, TXBuilt 1967 · S/N R-172-0242

Back to AD 87-20-03 R2