Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N5294Brown Kevin Lee · Broseley, MOBuilt 1971 · S/N MC-94 N5294LBreidenbach Amy K · Onalaska, WIBuilt 1968 · S/N 28-4595 N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508 N5294XCarrigan Roy K · Oak Grove, MNS/N 2220 N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642 N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644 N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824 N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559 N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941 N5295THayley Douglas Aviation Inc · Auburn, ALFirst renewal noticeBuilt 1972 · S/N 32-7240104 N5296BRobertson Ca · Phoenix, AZS/N 1158 N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050 N5296PFlanagan Robert Howard · Willows, CABuilt 1958 · S/N 24-337 N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510 N5296TGq Aviation LLC · Cherry Hill, NJBuilt 1972 · S/N 34-7250244 N5297BHughes Shaman · Cedaredge, COBuilt 1956 · S/N 1159 N5297LIndulgences Inc · Putnam Valley, NYBuilt 1968 · S/N 28-4599 N5297PMoretti Anthony · Deming, NMBuilt 1958 · S/N 24-338 N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511 N5297TMid Atlantic Air Museum · Reading, PABuilt 1972 · S/N 34-7250245 N5297WTausch Eddie W · Port Aransas, TXS/N 28-348 N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022 N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500 N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758 N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051 N5298PCroasdale Terry Lee · Modesto, CAS/N 24-339 N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512 N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396 N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501 N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349 N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654 N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501 N5299LSerafini Ronald S · Murphy, NCS/N 28-4601 N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744 N5299WPatterson Guy R Jr · Glencoe, KYBuilt 1962 · S/N 28-350 N529CANeufeld Don I · Fairview, OKS/N 17269104 N529CMHill Thomas Gerald · Port Tobacco, MDBuilt 2010 · S/N 40700 N529CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843925 N529DARegistration Pending · Travis Afb, CARegistration pendingBuilt 2020 · S/N 2881423 N529ECAlpha Tango LLC · Little River, SCBuilt 1975 · S/N 32R-7680072 N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356 N529HJsh Farms Inc · Hermiston, ORBuilt 1976 · S/N 1042 N529JAAnton Aaron · Poplar Grove, ILBuilt 1965 · S/N TD-617 N529JSNorthgate Enterprises LLC · Anchorage, AKBuilt 2005 · S/N 81846 N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970 N529LJRad Equipment Leasing Inc · Austin, TXBuilt 2004 · S/N 40.436 N529LWNelson Harry H · Orting, WABuilt 2005 · S/N 089 N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639 N529PTLt Express LLC · Carson City, NVBuilt 2002 · S/N T18208119 N529RBBusby Ralph H III Trustee · Newport, ORBuilt 1960 · S/N TD-417

Back to AD 87-10-06 R1