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.

N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854 N262GSMinor Michael D · Grove City, PAS/N 18265183 N262MGordon Bruce · Marstons Mills, MABuilt 1976 · S/N 17268356 N2630GMarvil Sean · El Prado, NMS/N 51930 N2630MMock Air LLC · Marion, INBuilt 1979 · S/N 17271166 N2630QParrington Robert · Rifle, COS/N 18257830 N2630RBurdine Kenneth L · Newland, NCS/N 18258330 N2630SDuquette Stephen R · Fenton, MIBuilt 1968 · S/N 337-0930 N2630VAgue Curtis M · Kailua, HIBuilt 1974 · S/N 177RG0636 N2630XBbjc Adventures LLC · Jackson, WIBuilt 1965 · S/N P206-0130 N2631CAndrews John M · Titusville, FLBuilt 1978 · S/N R18200183 N2631DHumphreys Grant R · Anchorage, AKBuilt 1952 · S/N 20783 N2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeBuilt 1965 · S/N 18256731 N2631GMac Neil David M · Clarkston, WABuilt 1959 · S/N 51931 N2631QManning Brian A · Malvern, IABuilt 1966 · S/N 18257831 N2632CSheldon Benjamin Lloyd · Duck Creek Village, UTBuilt 1978 · S/N R18200184 N2632DRech Timothy J · Camano Island, WAS/N 20784 N2632FOn Final Holdings LLC · West Olive, MIBuilt 1965 · S/N 18256732 N2632GHuey James M · Fulton, MOFirst renewal noticeBuilt 1959 · S/N 51932 N2632LKelley James M · Greenwood, ARBuilt 1967 · S/N 17255832 N2632SAvialogia Inc · Wilmington, DES/N 337-0932 N2633CWalusz Bernice J · Linden, NJS/N R18200185 N2633FYork Greg · Blanco, TXBuilt 1965 · S/N 18256733 N2633RDevries Mark R · Eagle River, AKBuilt 1967 · S/N 18258333 N2633SAir Apparent LLC · Santa Rosa, CAFirst renewal noticeBuilt 1968 · S/N 337-0933 N2634FCockerham Milton D · Gooding, IDBuilt 1965 · S/N 18256734 N2634JCupka Michael J · North Waterboro, MEBuilt 1966 · S/N 15065634 N2634LMetal Mistress Aviation LLC · Meadowview, VABuilt 1967 · S/N 17255834 N2634UCoolaire LLC · Boerne, TXBuilt 1963 · S/N 17250234 N2634VClanton Leslie G · Yazoo City, MSFirst renewal noticeBuilt 1948 · S/N 18144 N2635BGrimes Jeremy M · Wasilla, AKBuilt 1959 · S/N 50390 N2635CMason Gregory J · Rice Lake, WIBuilt 1978 · S/N R18200186 N2635GStockton Finance Inc · New Braunfels, TXBuilt 1959 · S/N 51935 N2635JWakefield Diep Thao T · Kelseyville, CABuilt 1966 · S/N 15065635 N2635KVerdi Stephen · Newtown, PABuilt 1978 · S/N 18053020 N2635LQueen Matthew E · Shenandoah, VAS/N 17255835 N2635RJong Hoon Cho · Rch Palos Vrd, CABuilt 1967 · S/N 18258335 N2635VLaycock Justin D · Johnson City, TNS/N 18145 N2636CSexton David Lee · Barnesville, GABuilt 1978 · S/N R18200187 N2636FCernilia James J · Newport Beach, CABuilt 1965 · S/N 18256736 N2636GHousken George E · Gardnerville, NVFirst renewal noticeBuilt 1959 · S/N 51936 N2636JScott William B · Owensville, INBuilt 1966 · S/N 15065636 N2636VMclaughlin Nathaniel D · Clayton, CABuilt 1958 · S/N 18146 N2637CSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N R18200188 N2637FMccrum James M · Seattle, WABuilt 1965 · S/N 18256737 N2637GSalisbury Jonathan T · Seabeck, WABuilt 1959 · S/N 51937 N2637LAustin Timothy · Abbeville, SCBuilt 1967 · S/N 17255837 N2637UMarks Charles A III · Apalachicola, FLBuilt 1963 · S/N 17250237 N2638DWallace Donald F · Palmer, AKBuilt 1952 · S/N 20790 N2638GEvans Steven H · Hattiesburg, MSBuilt 1959 · S/N 51938

Back to AD 87-20-03 R2