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.

N3313YCosta Flying Service Inc · Painted Post, NYS/N 18254313 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N3314VCurtiss Steve L · Fortine, MTS/N 15076458 N3314YSimas Filomeno M · Grover Beach, CABuilt 1962 · S/N 18254314 N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3315FSabbe Bros Flying Service Inc · Maddock, NDFirst renewal noticeBuilt 1966 · S/N 18257315 N3315JFlying Shiba Inus LLC · Dallas, TXS/N 15066015 N3315RTriple X Construction Inc · Camp Verde, AZBuilt 1967 · S/N 18258615 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3315VWirth Nicholas · Lake Geneva, WIBuilt 1977 · S/N R1722248 N3316JChipollini Jorge · Springdale, ARBuilt 1966 · S/N 15066016 N3316RBranstetter Jack · Ponca City, OKS/N 18258616 N3317FPeniston Mandy J · Chillicothe, MOBuilt 1966 · S/N 18257317 N3317RBanti Gustavo · Marco Island, FLBuilt 1967 · S/N 18258617 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N3317USierra Aviation LLC · Fond Du Lac, WIBuilt 1963 · S/N 18254717 N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N3318FIsland Aero LLC · Tavernier, FLBuilt 1966 · S/N 18257318 N3318RPetersen Family 1999 LLC · Anchorage, AKS/N 18502872 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N3318VArledge Roone Jr · Lakewood Ranch, FLBuilt 1977 · S/N R1722249 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664 N3319JWelch Cooper · Lee, FLBuilt 1980 · S/N 18803627 N331CBN331cb LLC · Great Falls, MTBuilt 1979 · S/N 21063747 N331DFDc-3 Pro Services LLC · Hailey, IDBuilt 1961 · S/N 185-0164 N331DTTolkach Dennis G · Dunlevy, PAS/N 18504238 N331JCCsp Aviation Holdings LLC · Dallas, TXBuilt 1966 · S/N 15064821 N331JTJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1972 · S/N 18501899 N331KWHeritage Academy Inc · Monterey, TNBuilt 1963 · S/N 3360026 N331LCEblc Aviation LLC · Hollywood, FLS/N U20605254 N331SPReinfeldt Phillip R · Burnsville, MNS/N 18268441 N3320DPara Tactics LLC · Shelton, WAS/N 32118 N3320FPoock Jerry D · Spencer, IABuilt 1966 · S/N 18257320 N3320JPollman Justin A · Sherwood, NDS/N 15066020 N33212Burlingame Lloyd · Fort Atkinson, WIBuilt 1976 · S/N 177RG0920 N33216Avarts LLC · New Castle, DES/N U20602676 N3321DWood Steveno · Morgan, UTS/N 32119 N3321FOwl Aviation LLC · Kingsport, TNBuilt 1966 · S/N 18257321 N3321JFulton Ricky L · Alex, OKBuilt 1966 · S/N 15066021 N3321RGray Kerry L · Granbury, TXBuilt 1967 · S/N 18258621 N3321TWilks Donald Leon · Flat Rock, ALBuilt 1967 · S/N 17700621 N3321VRegistered aircraftBuilt 1974 · S/N 15076462 N33220Advanced Analytical Inc · Newbury Park, CABuilt 1976 · S/N 177RG0925 N3322DObrien Aviation LLC · Moreno Valley, CABuilt 1955 · S/N 32120 N3322FCrystalline Entity · Los Angeles, CABuilt 1966 · S/N 18257322 N3322UPrecision Design Inc · Wilimington, DEBuilt 1963 · S/N 18254722 N3322YFostair Inc · Ovid, NYS/N 18254322 N33230Alaska Air Service LLC · Brookings, ORBuilt 1976 · S/N 177RG0930

Back to AD 87-20-03 R2