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.

N2824QAv8 LLC · Davenport, IAS/N 17259824 N2824SGolf Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 15066724 N2825CSouza Clifford A · Pattersonville, NYBuilt 1954 · S/N 26368 N2825FStephens Jeffrey G · Gig Harbor, WABuilt 1966 · S/N 18256925 N2825ROjeda Holdings LLC · Gainesville, GABuilt 1967 · S/N 18258425 N2825SShore Luke S · Elkin, NCBuilt 1967 · S/N 15066725 N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025 N2825YSalva Kenneth J · Shingle Springs, CABuilt 1962 · S/N 18253825 N2826AConfer Gary R · Washougal, WABuilt 1953 · S/N 30026 N2826CSolstice Joshua A · Anchorage, AKS/N 26369 N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026 N2826QMcmillan Roger L · Camdenton, MOBuilt 1971 · S/N 17259826 N2826UJohnson James E · College Station, TXBuilt 1963 · S/N 17250426 N2827CCalifornia Equipment Leasing LLC · Marina Del Rey, CABuilt 1978 · S/N R18200233 N2828ALatham Cory D · Great Bend, KSS/N 30028 N2828FSmiley Neil J Trustee · Lake Havasu City, AZBuilt 1966 · S/N 18256928 N2828KStephens Mark Edwin Trustee · Morgan Hill, CABuilt 1979 · S/N 18053091 N2828QJack Dixon · Haiku, HIBuilt 1971 · S/N 17259828 N2828XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700228 N2828YHooey Kevin M · Beaver Dams, NYBuilt 1962 · S/N 18253828 N2829EEverts Air Service Inc · Sarasota, FLBuilt 1978 · S/N 17271336 N2829LGeaux Fly LLC · Bossier City, LAS/N 17256029 N2829QL & L Aviation LLC · Sidney, NEBuilt 1971 · S/N 17259829 N2829XHannam Michael J · Runnells, IABuilt 1967 · S/N 17700229 N2829YN2829y LLC · Longmont, COFirst renewal noticeBuilt 1962 · S/N 18253829 N282CPWright Andrew T · Clyde, OHBuilt 1958 · S/N 51546 N282EL282el LLC · Pendleton, ORS/N 182-67682 N282JPMarshalls Sanitation Services LLC DBA · Fallon, NVBuilt 1977 · S/N 18265923 N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068 N282RFDevault Michael E · Fairmont, WVBuilt 1968 · S/N 18259466 N282TWLake Of The Woods Aviation LLC · Baudette, MNBuilt 1977 · S/N 18265943 N2830LPilotpros Training LLC · Longview, TXBuilt 1967 · S/N 17256030 N2830QRetro Modern Aviation LLC · Manitou Springs, COBuilt 1971 · S/N 17259830 N2830RCae Flying Club Of Ohio · Toledo, OHBuilt 1967 · S/N 18258430 N2830XCollins Stanley T · Elizabethtown, KYBuilt 1967 · S/N 17700230 N2831CMohar Fred B Jr · Turner, MTBuilt 1954 · S/N 26374 N2831KBjorkman Glenn A · Goleta, CABuilt 1979 · S/N 18053092 N2831LJkj Flying LLC · Chittenango, NYBuilt 1967 · S/N 17256031 N2831USchmidt Paul D · Whitesburg, GABuilt 1963 · S/N 17250431 N2832CVandehei Linda I · Fairbanks, AKBuilt 1954 · S/N 26375 N2832RMabe Bradley L · Cascade, IDBuilt 1967 · S/N 18258432 N2832SMeyer Philipp J · Sioux Falls, SDBuilt 1967 · S/N 15066732 N2832URegistration Pending · Wasilla, AKRegistration pendingS/N 17250432 N2833AMamuzich Robert J DBA · Deming, NMS/N 30033 N2833CKizer Charlene A · Albany, ORBuilt 1978 · S/N R18200234 N2833LWade Kenneth L · Huron, TNBuilt 1967 · S/N 17256033 N2833RRegistered aircraftS/N 18258433 N2833YLancaster Mark E · Buffalo, SCBuilt 1962 · S/N 18253833 N2834ADalton John B · Dallas, ORBuilt 1953 · S/N 30034 N2834COsborne David A · San Antonio, TXBuilt 1978 · S/N R18200235

Back to AD 87-20-03 R2