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.

N5389DRegistered aircraftBuilt 1958 · S/N 50289 N5389KMcconnell Cynthia D · New Smyrna Beach, FLBuilt 1980 · S/N 17274092 N5389MChapel Hill Flying Club DBA · Sanford, NCBuilt 1980 · S/N 15284576 N5389QCieri Joe · Graves Mill, VABuilt 1981 · S/N 15285107 N5389RTetrault David E · Largo, FLBuilt 1965 · S/N 17252925 N5389TChadwell Letch J · Hulbert, OKBuilt 1964 · S/N 17251289 N538CJav Air Services LLC · Anchorage, AKBuilt 1981 · S/N 17274724 N538PCFontaine Scott M · Salt Lake City, UTBuilt 1963 · S/N 18051328 N538TBCorum Richard E Jr · Clemmons, NCBuilt 1963 · S/N 17249965 N5390E402wd Holdings LLC · Robstown, TXBuilt 1979 · S/N 18503961 N5390NLarsen Steve J · Colton, ORBuilt 1980 · S/N 18267684 N5390QIgnarro Jessie · Bay Shore, NYS/N 15073290 N5390RSmith James H · Fordyce, ARBuilt 1965 · S/N 17252926 N5390TBakker Johanna · Spokane, WABuilt 1964 · S/N 17251290 N5390VSpringfield Flying Service LLC · Columbia, CABuilt 1980 · S/N 172RG0518 N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408 N5391DPope James D · Lewiston, IDBuilt 1958 · S/N 50291 N5391HHansen Alvin Kent · Winamac, INBuilt 1975 · S/N 17265419 N5391QMja Aviation LLC · Channahon, ILBuilt 1972 · S/N 15073291 N5391TV Y Aviation LLC · Gentry, ARS/N R18201862 N5392QLatitude Aviation LLC · Cedar Rapids, IAS/N 15073292 N5392TStarkovich James M · Arlington, WABuilt 1964 · S/N 17251292 N5393NRegistration Pending · Craig, CORegistration pendingBuilt 1980 · S/N 18267686 N5393TTinseth Lance D Trustee · Highlands Ranch, COBuilt 1966 · S/N 18257628 N5393VPeterson Gary E · Bainbridge Island, WAS/N 172RG0519 N53945Lewis Robert · Chandler, AZBuilt 1981 · S/N 17274832 N5394BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283859 N5394DBruce Gregory L · Yelm, WABuilt 1958 · S/N 50294 N5394TBigler Danny L · Owasso, OKBuilt 1964 · S/N 17251294 N5394XL K Hollenbeak Logging Inc · Hayfork, CABuilt 1980 · S/N U20605710 N5395BRosecrans Robert Michael · Emmett, IDBuilt 1956 · S/N 33395 N5395DLindberg Thomas W · Anchorage, AKBuilt 1958 · S/N 50295 N5395HHansen James R · Kenmore, WABuilt 1975 · S/N 17265421 N5395NDelaware Horizon Properties LLC · Lewes, DEBuilt 1980 · S/N 18267688 N5395QOwens John C · Mount Carmel, PABuilt 1972 · S/N 15073295 N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930 N5396BGreene County Sport Parachute Center Of Ky Inc · Loretto, KYBuilt 1956 · S/N 33396 N5396ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17271842 N5396RPrecocity Academy LLC · Gibsonia, PABuilt 1965 · S/N 17252933 N5396TMclaughlin Daniel J · Elbridge, NYBuilt 1964 · S/N 17251296 N5397DRandall William G · Oklahoma City, OKS/N 17272563 N5397RIowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263530 N5398TSandstrom Mark · Minot, NDBuilt 1964 · S/N 17251298 N53996Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1981 · S/N 17274836 N5399BLudian Malgorzata · Bakersfield, CABuilt 1979 · S/N 15283861 N5399DWeeks Patrick · Anchorage, AKBuilt 1958 · S/N 50299 N5399EAerocraft LLC · Durango, COS/N 18268314 N5399JMann Aviation Inc · Long Beach, CAS/N 17273779 N5399KColemanation Investments LLC · Naperville, ILBuilt 1980 · S/N 17274095 N539BXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15283898

Back to AD 87-20-03 R2