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.

N2SKRegistered aircraftBuilt 1980 · S/N 172RG0666 N2SLLowe Aviation LLC · Bountiful, UTBuilt 1977 · S/N 21061908 N2SSFlying M Aircraft LLC · Kuna, IDBuilt 1952 · S/N 19980 N2TAMontgomery Keith L · Florence, ALBuilt 1972 · S/N 15073811 N2TGB2c2 Aviation LLC · Piedmont, CABuilt 1969 · S/N 337-1064 N2TPHanchett James R · Cheboygan, MIBuilt 1963 · S/N 17250269 N2WSeldom Seen Aviation Northwest Inc · Stevensville, MTS/N 185-02982 N2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849 N2XCMiller Virgil J · Milton Freewater, ORS/N 17266833 N2XNDudebuddy Aviation LLC · Kalispell, MTBuilt 1980 · S/N 18267615 N2YROverland Missions Inc · Cocoa, FLS/N U20601737 N2ZDMelin Lynn Glenn · Scottsdale, AZBuilt 1974 · S/N 18262867 N300Texas Sky Masters Inc DBA · Dallas, TXBuilt 1976 · S/N P3370236 N3000QFlying H Enterprises · Santa Fe, NMBuilt 1967 · S/N 18258000 N3000TN3000t LLC · Townsend, GABuilt 1967 · S/N 337-0600 N3000UMerrell Warren W · Idalou, TXBuilt 1963 · S/N 17250600 N3000YChesebro Ben D · Tucson, AZBuilt 1962 · S/N 18254000 N30013Patton Mark E · Dryden, NYBuilt 1968 · S/N 17701023 N30014Tri-State Aviators LLC · Ironton, OHBuilt 1968 · S/N 17701024 N30017Landon Kasiri · Lancaster, CABuilt 1968 · S/N 17701025 N3001BLarsen James · Santa Rosa, CABuilt 1952 · S/N 7884 N3001UPrairie Flyers · Rocky Ford, COBuilt 1963 · S/N 17250601 N3002QJaeger Christopher E · Normandy Park, WABuilt 1967 · S/N 18258002 N3002YGiefer Brett T · Nicollet, MNBuilt 1962 · S/N 18254002 N30033Mission Aviation Training Academy · Arlington, WABuilt 1968 · S/N 17701036 N30038Stockyard LLC · Wilmington, DEBuilt 1973 · S/N 21059879 N3003ETuskegee Airmen National Historical Museum · Detroit, MIBuilt 1978 · S/N 17271400 N3003FHassinger Farms LLC · Cove, ORBuilt 1966 · S/N 18257103 N3003JCoastal Valley Aviation · Santa Maria, CABuilt 1965 · S/N 15061103 N3003XAero Flyers LLC · Stephenson, VABuilt 1966 · S/N 15064403 N30040Schaller Neil J · New Athens, ILBuilt 1968 · S/N 17701043 N30043Singer Mark D · Stafford, VABuilt 1968 · S/N 17701045 N30044Air Data Solutions LLC · Natchitoches, LABuilt 1968 · S/N 17701046 N3004ABaan Richard J · Live Oak, FLBuilt 1953 · S/N 25648 N3004BDirksen Daniel L · Montevideo, MNBuilt 1952 · S/N 7887 N3004FN3004f LLC · Cranberry Township, PABuilt 1966 · S/N 18257104 N3005AMarquiss Merritt L · Gillette, WYBuilt 1953 · S/N 25649 N3005BStreamline Aviation LLC · Battlefield, MOS/N 7888 N3005FE & E Jones Farms LLC · Munford, ALBuilt 1966 · S/N 18257105 N3005SSpennato Peter Jr · Rolling Hills, CABuilt 1967 · S/N 15066905 N3005XOso Air LLC · Missoula, MTBuilt 1966 · S/N 15064405 N30064Avarix Inc · Cool, CAS/N 17701053 N3006ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1953 · S/N 25650 N3006BMabry Thomas Coleman II · Atlanta, GABuilt 1952 · S/N 7889 N3006QHarrington Michael L · Twin Falls, IDS/N 18258006 N3006SGrice Warren A · Marshall, ARBuilt 1967 · S/N 15066906 N3006XRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1966 · S/N 15064406 N3006YWissner Martin L · Carpenter, WYBuilt 1963 · S/N 18255082 N3007AFly8ma LLC · Big Lake, AKBuilt 1953 · S/N 25651 N3007FTroelstra Frederick D · Queensbury, NYBuilt 1966 · S/N 18257107

Back to AD 87-20-03 R2