Registered aircraft · 54,019

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.

N278SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0571 N2790DRegistered aircraftBuilt 1952 · S/N 25332 N2790GBryan Roger J · Spearfish, SDBuilt 1959 · S/N 52090 N2790JLock Robert Allen · Grand Haven, MIBuilt 1975 · S/N A1500602 N2790LWells Mark L · Eads, TNBuilt 1967 · S/N 17255990 N2790QArthur Lloyd T · Greenfield, INS/N 18257990 N2791GHoutte Edmund Michael DBA · Palmer, AKBuilt 1959 · S/N 52091 N2791JPuget Sound Flyers Inc · Everett, WABuilt 1975 · S/N A1500603 N2792CBerg Timothy J · Fairbanks, AKBuilt 1954 · S/N 26336 N2792FRoshong Loman · Leesville, LABuilt 1966 · S/N 18256892 N2792GSpeedstar Aviation LLC · Kalispell, MTBuilt 1959 · S/N 52092 N2792JAndresen Leonard W · Anchorage, AKBuilt 1969 · S/N 185-1542 N2792QPalmer Paul F · Donnelly, IDBuilt 1967 · S/N 18257992 N2793GMeyer Steven D · Snohomish, WABuilt 1959 · S/N 52093 N2794DBrown Rayford K · Temple, TXBuilt 1952 · S/N 25336 N2794GClark Jeremiah Jacob · Pleasant Plains, ARBuilt 1959 · S/N 52094 N2794JRegistration Pending · Anchorage, AKRegistration pendingBuilt 1969 · S/N 185-1546 N2794QVincer Way LLC · Centennial, COBuilt 1967 · S/N 18257994 N2795CCales Jack R · Edisto, SCBuilt 1954 · S/N 26339 N2795FRegistration Pending · Marietta, GARegistration pendingBuilt 1966 · S/N 18256895 N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650 N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995 N2795URichardson Robert S · Austin, TXBuilt 1963 · S/N 17250395 N2796DFrance Gregory G · Alta Loma, CABuilt 1952 · S/N 25338 N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896 N2796GDouglas Cattle LLC · Douglas, AZBuilt 1959 · S/N 52096 N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996 N2797DEberhart Wayne Willis · Amboy, MNBuilt 1952 · S/N 25339 N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324 N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897 N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555 N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228 N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325 N2798FGoodall Maurice M II · Omak, WABuilt 1966 · S/N 18256898 N2798GBremerton City Flying Club · Poulsbo, WABuilt 1959 · S/N 52098 N2798JCenter Of Gravity Flying Club LLC · Monterey, CABuilt 1975 · S/N A1500607 N2798XElsner Kelly John · Menahga, MNBuilt 1965 · S/N 18051598 N2799CTaylor James L · Lowell, ARBuilt 1954 · S/N 26343 N2799GMartin Aviation LLC · Scottsboro, ALS/N 52099 N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592 N2799UWinslow Linda S Trustee · Creswell, ORS/N 17250399 N2799XHess James R · Heathsville, VABuilt 1965 · S/N 18051599 N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822 N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499 N279MCMagic Carpet LLC · Wilmington, DEBuilt 1954 · S/N 26331 N279RWPoe James K · Walterboro, SCBuilt 1959 · S/N 52347 N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306 N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826 N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108 N27CSFeauto Aviation Inc · Saint Cloud, FLBuilt 1964 · S/N 17251680

Back to AD 87-20-03 R2