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.

N7074SBoening Bros Dust & Spray Svc · Floresville, TXBuilt 1967 · S/N 15067774 N7074TNielson Dean A · Inchelium, WABuilt 1959 · S/N 46674 N7074ZCopper River Airmotive LLC · Copper Center, AKS/N 17274467 N7075AStonebrink Arnold · Payson, AZS/N 29175 N7075FGillette Timothy R · Ipswich, MABuilt 1966 · S/N 15063675 N7075GDraper Floyd L · El Paso, TXBuilt 1969 · S/N 17258775 N7075MPs Aviation Inc · Granada, MNBuilt 1958 · S/N 55375 N7075QCorell Ryan J · Mason City, IAS/N 17260375 N7076QAbbott Brett C · Leawood, KSBuilt 1972 · S/N 17260376 N7076SHaeg Timothy R · Saint Joseph, MNBuilt 1967 · S/N 15067776 N7076TLuebke Harold W Jr · Stuttgart, ARBuilt 1959 · S/N 46676 N70771Golike Robert E · Eagle River, AKBuilt 1960 · S/N 52397 N70778Engleman Aviation LLC · Comfort, TXBuilt 1968 · S/N 18259366 N70788Mercier Michael S · Chugiak, AKBuilt 1970 · S/N 18052117 N7079ADerbe LLC · Durham, NCBuilt 1956 · S/N 29179 N7079MArmstrong Bruce · Port Orchard, WABuilt 1958 · S/N 55379 N707ATSpacely Space Sprockets LLC · Aurora, ORBuilt 1977 · S/N 17268611 N707BSConboy Enterprises LLC · Lexington, KYS/N 18253773 N707CDPadilla Luis Antonio Jr · Brownsville, TXBuilt 1963 · S/N 21058207 N707CGMohler Mark R · Green Cove Springs, FLBuilt 1977 · S/N 177RG1310 N707CTShaak John C · Newnan, GABuilt 1978 · S/N R18200320 N707DRRichardson Douglas · Goodlettsville, TNBuilt 1970 · S/N 17701458 N707ERCrossbrook LLC · Willoughby, OHBuilt 1977 · S/N 21062337 N707GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279648 N707JYBest Glide LLC · Davie, FLS/N 17253465 N707KVieques Aero Club LLC · Ouray, COBuilt 1963 · S/N 205-0439 N707KWWaters Aero Marine Inc · South Thomaston, MEBuilt 1975 · S/N U20602619 N707MTams LLC · North Las Vegas, NVS/N 15065924 N707MGTawoda Leanne · Sun City, AZBuilt 1959 · S/N 52073 N707PPattison Bradley D · Gig Harbor, WABuilt 1975 · S/N 17266295 N707REHamm Mark W · Eagle River, AKBuilt 1952 · S/N 20389 N707RLApplegate Properties LLC · Morris, ILS/N T303-00008 N707UJInternational Air Services Inc Trustee · Carson City, NVS/N 17262019 N707WCAcp Aviation LLC · Oakdale, LABuilt 1973 · S/N 18052347 N707WJLandry Don T · Thousand Oaks, CABuilt 1977 · S/N U20604054 N707XJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 17701340 N70800Gangloff William A Jr · Frederick, MDS/N 18259367 N70802Brandvik Pipe & Equipment Inc · Borger, TXBuilt 1968 · S/N 18259369 N70804Fanning Fred W · Fairlawn, OHBuilt 1968 · S/N 18259370 N70809Inman Steve J · Billings, MTBuilt 1968 · S/N 18259373 N7080ARedmon Michael P · Canal Winchester, OHBuilt 1956 · S/N 29180 N7080EHamdan Isam · Tulsa, OKBuilt 1960 · S/N 56580 N7080MMelvin Scott W · Cookson, OKBuilt 1958 · S/N 55380 N7080QFerraro Paul · Seattle, WABuilt 1972 · S/N 17260380 N7080TKingdom Planes LLC · Decatur, TXBuilt 1959 · S/N 46680 N70810Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602097 N70816Proctor Keith · Paint Lick, KYS/N 18259378 N7081ASeibert Edwin M · Swansea, SCBuilt 1956 · S/N 29181 N7081EMedley Matthew C · Shelbyville, INBuilt 1960 · S/N 56581 N7081FHayes Travis · Harrisonville, MOBuilt 1966 · S/N 15063681

Back to AD 87-20-03 R2