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.

N3118UMaytown Sport Parachute Club · Marietta, PABuilt 1962 · S/N 18254518 N3118VKemper Joseph C · Coxs Mills, WVBuilt 1974 · S/N 15076390 N3118XMoody Dalton T · Evansville, INBuilt 1966 · S/N 15064518 N3118YTeerlink Craig N Trustee · Cedar Hills, UTBuilt 1962 · S/N 18254118 N3119AMouw Trea C · Chino, CABuilt 1953 · S/N 25763 N3119FAbsolute Fencing LLC · Granger, WABuilt 1966 · S/N 18257219 N3119JBerthelsen Mark A · Baker City, ORBuilt 1966 · S/N 15065819 N3119RChern Jeffrey · Oakland, CABuilt 1967 · S/N 18258519 N3119SFinch Michael J · Springfield, TNS/N 18255619 N311CFHronkin Jessie G · Palmer, AKBuilt 1974 · S/N 18502496 N311EHFive Six Zero One LLC · Orange, CABuilt 1977 · S/N 17269158 N311HBChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272347 N311JBJack Brain And Associates Inc · Castro Valley, CAS/N P21000539 N311MMAndrews Karen · Napa, CABuilt 1978 · S/N R18200366 N311SFBaymag Aviation LLC · Mountain Home, ARBuilt 1968 · S/N 18259047 N311SGRapattoni Ryan · Los Angeles, CABuilt 1969 · S/N 15071161 N311TLM & N Enterprises LLC · Topeka, KSBuilt 1981 · S/N 18267937 N3120BRustad Scott K · Minot, NDBuilt 1952 · S/N 25362 N3120FLengyel Roger · Santa Fe, NMBuilt 1966 · S/N 18257220 N3120QLinda In The Sky LLC · Webster, MNBuilt 1967 · S/N 18258120 N3120RBulang Investments LLC · Newbury, NHS/N 18258520 N3121DFrey Jerry P · Fallon, NVBuilt 1955 · S/N 31919 N3121FLily Chris H · Ocala, FLBuilt 1966 · S/N 18257221 N3121THall Tyler · Billings, MTS/N 17700421 N3122AJohns William D · Lodi, CABuilt 1953 · S/N 25766 N3122JMulvihill Murphy A · Northbrook, ILBuilt 1966 · S/N 15065822 N3122STecumseh Skydiving School LLC · Tecumseh, MIBuilt 1964 · S/N 18255622 N3122YJti Management LLC · Colfax, WAS/N 18254122 N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922 N3123EKanase Padmaneel B · Amarillo, TXS/N 17271444 N3123QDarkhorse Six Inc · Boerne, TXBuilt 1967 · S/N 18258123 N3123RHs Aviation Holdings LLC · Eagle, IDBuilt 1967 · S/N 18258523 N3123SGabin LLC · Tulsa, OKBuilt 1964 · S/N 18255623 N3123VColemaker Aero & Marine LLC · Saint Augustine, FLBuilt 1974 · S/N 15076392 N3123XRegistered aircraftBuilt 1966 · S/N 15064523 N3123YAbecca Corporation · Jackson, MIBuilt 1962 · S/N 18254123 N3124AWolstenholme Robert · Line Lexington, PABuilt 1953 · S/N 25768 N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922 N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224 N3124RMidland Liberty LLC · Midland, MIBuilt 1967 · S/N 18258524 N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923 N3125FHall Aircraft LLC · Kenai, AKS/N 18257225 N3125QSunrise Aviation Llp · Gig Harbor, WABuilt 1967 · S/N 18258125 N3125THamilton Brian H · Currie, MNBuilt 1967 · S/N 17700425 N3125WRowe Benjamin Stratton · Nome, AKBuilt 1959 · S/N 50584 N3125YOberdoerster Timothy L · Concord Township, OHS/N 18254125 N3126ALutz Adam R · Kodiak, AKBuilt 1953 · S/N 25770 N3126CWest Leland Dan · Elverta, CAS/N 30925 N3126DMyers Martin John Trustee · Juneau, AKBuilt 1955 · S/N 31924 N3126EN3126e LLC · Columbus, OHBuilt 1978 · S/N 17271446

Back to AD 87-20-03 R2