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.

N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485 N8220BTurner Travis Joseph · Chetek, WIS/N 36020 N8220LFlywyo LLC · Kalispell, MTBuilt 1967 · S/N 17256420 N8220SHammack Lindsey M · Westlake, TXBuilt 1965 · S/N 15061820 N8220XGundry James A · Fall Creek, WIBuilt 1961 · S/N 17248720 N8221BMayberry Jonathan J · Lake Stevens, WABuilt 1957 · S/N 36021 N8221FSale Reported · Eau Claire, MISale reportedBuilt 1966 · S/N 15064321 N8221GIshoy Glen · Indiana, PABuilt 1971 · S/N 177RG0121 N8221LAntholz John C · Apple Valley, MNBuilt 1967 · S/N 17256421 N8221VBorror Bryce C · Grants Pass, ORBuilt 1966 · S/N 18051723 N8221XPegasus Endeavors LLC · Kalispell, MTBuilt 1961 · S/N 17248721 N8221ZHaralson Douglas K · Kenai, AKBuilt 1963 · S/N 205-0221 N8222LSimpson Roger E Sr · Moncks Corner, SCBuilt 1967 · S/N 17256422 N8222MFrank Sherril P · Grapevine, TXBuilt 1969 · S/N 21059222 N8222UCramer Bill · Oxnard, CABuilt 1964 · S/N 17252122 N8222XFoster Neal W · Nome, AKBuilt 1961 · S/N 17248722 N8223ASmith Mathias N · Weiser, IDS/N 25075 N8223FSoderman David W · Gilby, NDBuilt 1966 · S/N 15064323 N8223LO'Connor Aidan J · East Moriches, NYBuilt 1967 · S/N 17256423 N8223SRedditt William L · Erie, PABuilt 1965 · S/N 15061823 N8223UChapter 36 Flying Club Inc · Hagerstown, MDBuilt 1964 · S/N 17252123 N8223X23xray LLC · Houston, TXBuilt 1973 · S/N 18262586 N8224ESudano Richard L · Cordova, AKBuilt 1959 · S/N 26656 N8224FDiamond David Z · Wrentham, MABuilt 1966 · S/N 15064324 N8224GSkylarkers Inc · Farmington, NMBuilt 1971 · S/N 177RG0124 N8224LCamp Lake Aircraft LLC · Salem Lakes, WIBuilt 1967 · S/N 17256424 N8224MGreene Dennis M · Desert Hot Springs, CAS/N 18264567 N8224TBeausoleil Randy L · Livingston, TXS/N 17556924 N8224UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N 17252124 N8224ZGloria Glenn Inc DBA · Roswell, NMFirst renewal noticeBuilt 1963 · S/N 205-0224 N8225AFast Track Aircraft LLC · Oxford, MSBuilt 1952 · S/N 25077 N8225BConner Mark Wes · Thomasville, NCBuilt 1957 · S/N 36025 N8225HLout James M · Jasper, TXS/N 18260681 N8225LWebb George Q · Monroe, GAS/N 17256425 N8225MCarlson Farms Inc · Plentywood, MTBuilt 1969 · S/N 21059225 N8225QCartoflight Inc · Willoughby, OHBuilt 1976 · S/N U20603109 N8225YInternational Air Services Inc Trustee · Carson City, NVFirst renewal noticeBuilt 1977 · S/N 177RG1247 N82266Klondike International LLC · Lewes, DEBuilt 1957 · S/N 32971 N8226BPerez Emanuel A · Calistoga, CABuilt 1957 · S/N 36026 N8226FPrahin Michael H · Novi, MIBuilt 1966 · S/N 15064326 N8226TDrain Jerald R · Gainesville, FLBuilt 1960 · S/N 17556926 N8227AJin Jin Aviation LLC · Anchorage, AKBuilt 1952 · S/N 25079 N8227BSegovia Nicholas A · Mooresville, NCBuilt 1957 · S/N 36027 N8227GKritz Eric J · Gualala, CABuilt 1971 · S/N 177RG0127 N8227SKashani Asher Farzan · Reseda, CABuilt 1965 · S/N 15061827 N8227TFulenchek Raymond D · Sherman, TXBuilt 1960 · S/N 17556927 N8227UGeiger Russell K · Hilliard, FLBuilt 1964 · S/N 17252127 N8227XMitchell Randall Dean · New Hampton, IABuilt 1961 · S/N 17248727 N8227ZGa 27z LLC · Arlington, WABuilt 1963 · S/N 205-0227 N8228Cross John · Canton, OHBuilt 1965 · S/N 17252520

Back to AD 87-20-03 R2