Registered aircraft · 54,015

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.

N6383AGardner Frankie J · Mount Vernon, ARBuilt 1956 · S/N 33183 N6383BLewark Larry D · Frisco, COBuilt 1957 · S/N 34283 N6383FWilliams William C Jr · Houston, TXFirst renewal noticeBuilt 1979 · S/N 17273213 N6383HWest Brian L · Creston, IABuilt 1973 · S/N 15074956 N6383KMock Joseph R · Huntsville, TXBuilt 1975 · S/N 15077677 N6383SNightingale Matthew · Rancho Cucamonga, CABuilt 1967 · S/N 15067183 N6383TLetourneau David · Valencia, CABuilt 1985 · S/N R18202004 N63843Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17275490 N6384DN2893e LLC · Reno, NVBuilt 1979 · S/N 17272770 N6384SSalter William Jeffrey · New Smyrna Beach, FLS/N 15067184 N63852Richmor Aviation Inc · Scotia, NYBuilt 1981 · S/N 17275491 N6385ELucky Dog Land Co LLC · Caldwell, IDBuilt 1959 · S/N 46485 N6385PBada Alfredo · Mcallen, TXBuilt 1978 · S/N P21000173 N6385SPalmer Dana G · Gatesville, TXS/N 15067185 N6386CBas Part Sales LLC · Greeley, COS/N 21063879 N6386ER M Aviation Inc · Lakeview, MIBuilt 1979 · S/N 17272013 N6386FRasys Paul J · Lawton, OKBuilt 1966 · S/N 337-0386 N6386GSonafrank Eric · Somerset, INBuilt 1970 · S/N 15071886 N6386TPaul Taylor Consulting LLC · Albuquerque, NMBuilt 1985 · S/N R18202005 N6386VSaunders Andreas · Wake Forest, NCS/N 172RG0649 N6387BSparrow Hawk Aviation LLC · Moraine, OHBuilt 1979 · S/N 15283927 N6387FMitich Nathan · Fort Worth, TXBuilt 1980 · S/N 17273214 N6388DBdo Aviation LLC · Dallas, TXBuilt 1979 · S/N 17272774 N6388GGaller Frank G · Elysian, MNBuilt 1970 · S/N 15071888 N6388TLuribay Corp · Wilmington, DEBuilt 1984 · S/N R18202007 N6388YMaclean Kenneth J · Northborough, MABuilt 1981 · S/N 21064359 N6389BGc Aviation Services-1 LLC · Miamisburg, OHS/N 15283928 N6389FSymms Fruit Ranch Inc · Caldwell, IDBuilt 1975 · S/N 18264185 N6389GHagen Alfred · Bensalem, PABuilt 1970 · S/N 15071889 N6389WSpenco Inc · Sale Creek, TNBuilt 1981 · S/N P21000764 N6390BPalmer Bryce P · Chugiak, AKBuilt 1957 · S/N 34290 N6390ERyan Michael P · Melrose, IAFirst renewal noticeBuilt 1959 · S/N 46490 N6390SStraub Aircraft Holdings LLC · Overland Park, KSBuilt 1967 · S/N 15067190 N63918Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17275495 N6391EDay Stephen F · Queen Creek, AZBuilt 1959 · S/N 46491 N6391JAty Aviation Inc · Watertown, SDBuilt 1980 · S/N 17273868 N6391SWest Steven A Jr · San Angelo, TXBuilt 1980 · S/N R18201669 N6391TWebco Aviation LLC · Clay, KYBuilt 1985 · S/N R18202009 N6391UGimli Son LLC · Fort Lauderdale, FLBuilt 1979 · S/N U20605472 N6392ARlf Aviation LLC · Peachtree Corners, GABuilt 1956 · S/N 33192 N6392BHubatka Wilferd · Creston, IAFirst renewal noticeBuilt 1957 · S/N 34292 N6392CTretter Nicholas · Holden, MABuilt 1980 · S/N 21063880 N6392EWinds Aloft Inc · Lakeland, FLBuilt 1983 · S/N 18268366 N6392GJtw Aero Leasing LLC · Frederick, MDBuilt 1979 · S/N 17273592 N6392YBoldflight LLC · Greenwood, INBuilt 1975 · S/N 17264795 N6392ZFlorence Michael · Portsmouth, NHBuilt 1981 · S/N U20606264 N6393ALadmill Investments LLC · Gulfport, MSBuilt 1956 · S/N 33193 N6393BLebard Racquele J · Sparks, NVBuilt 1957 · S/N 34293 N6393EBrewster Richard D · Bellvue, COBuilt 1959 · S/N 46493 N6393GKrusell Robert S · Blairsville, GABuilt 1979 · S/N 17273593

Back to AD 87-20-03 R2