Registered aircraft · 54,017

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.

N4570KHead East Aviation LLC · Geneseo, ILBuilt 1979 · S/N P21000220 N45714Brumagin James R · Tulalip, WABuilt 1975 · S/N 15077032 N4571BSchumacher Eraine · Hague, NDBuilt 1955 · S/N 31470 N4571UMcguffee James Darron · Columbia, LABuilt 1964 · S/N 15060571 N45720Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 15077035 N4572BPagel Jeffrey · Wasilla, AKBuilt 1955 · S/N 31471 N4572FRichards Stewart G · North Palm Beach, FLBuilt 1966 · S/N 185-1079 N4573FNapflin Erich P · Wasilla, AKBuilt 1966 · S/N 185-1080 N4573UMulder Timothy D · Shafter, CAS/N 15060573 N4574FKlingenmeyer Korey L · Anchorage, AKBuilt 1966 · S/N 185-1081 N4574UAirmotive Service LLC · Brigham City, UTBuilt 1964 · S/N 15060574 N4574VSmtm Holdings Inc · Wilmington, DES/N 17266358 N4575BKrupinshi Floyd M · Chugiak, AKBuilt 1955 · S/N 31474 N4576CFrench David C · Mc Alpin, FLBuilt 1953 · S/N 25520 N4576KPope James Dean · Lewiston, IDBuilt 1979 · S/N P21000222 N4577BHorsley David L · El Paso, TXBuilt 1955 · S/N 31476 N4577CKoinzan Seed And Flying Service Inc · Elgin, NEBuilt 1953 · S/N 25521 N4579FWagner Jan W · Lopez Island, WAS/N 185-1086 N4579USquiers Frederick Eugene · Barre, VTS/N 15060579 N457AESahni Irvin K · Seguin, TXBuilt 1967 · S/N 15066592 N457BCMorris Thomas Z Trustee · Spokane Valley, WABuilt 1974 · S/N 17264589 N457DLLeis Donald E · Greenville, OHBuilt 1970 · S/N 18260404 N457GGBohl Howard M · Temecula, CAS/N 15060269 N457SKWorld Marketing Syndicate I · Wilmington, DEBuilt 1975 · S/N 17264736 N4580EDe Baca Land & Cattle LLC · Jacksboro, TXBuilt 1982 · S/N 18268244 N4580JBlakeslee Mark C · Kodiak, AKBuilt 1975 · S/N 180-52509 N4580KHarrah Daniel R · Juneau, AKBuilt 1979 · S/N P21000223 N4580UDean Nolan W · Harrisonburg, VABuilt 1964 · S/N 15060580 N4581CGerardy Harlan D · Gruver, TXBuilt 1953 · S/N 25525 N4582CBontrager Brian S · Wasilla, AKBuilt 1953 · S/N 25526 N4582ERelis Enterprises LLC · Ravenel, SCBuilt 1982 · S/N 18268245 N45835Yoakam John A · North Ridgeville, OHS/N 177RG0756 N4583CWood L Paul · Bridgeport, TXS/N 25527 N4584BNadon Peter M · Aztec, NMBuilt 1955 · S/N 31483 N4584CEco Resources Inc · Millersport, OHBuilt 1953 · S/N 25528 N4584UDavis Jubal L · Waverly, OHBuilt 1964 · S/N 15060584 N4585BWalchshauser Scott A · Double Oak, TXBuilt 1955 · S/N 31484 N4585CTempero Clair R · Worden, MTBuilt 1953 · S/N 25529 N4586BGochenaur Dwight W · York Springs, PABuilt 1955 · S/N 31485 N4586UCate Randall L · Knoxville, TNFirst renewal noticeBuilt 1964 · S/N 15060586 N4587CJackson Marshall L II · Rock Hill, SCBuilt 1953 · S/N 25531 N4589CNelson David W · Marengo, ILBuilt 1953 · S/N 25533 N458DJSurvey America Inc · Rancho Cordova, CABuilt 1980 · S/N U20605833 N458SRDr2 Aviation LLC · Valdosta, GABuilt 1972 · S/N 18261409 N4590BFulltron Aviation LLC · Springfield, MOBuilt 1979 · S/N 15283545 N4590PWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284774 N45915Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 15282943 N4591UJacobsen Ian M · Lincoln City, ORBuilt 1964 · S/N 15060591 N45928Cohan Thomas A · Sparks, NVBuilt 1978 · S/N 15282945 N4592CKelley Stephen Mark · Kamiah, IDBuilt 1953 · S/N 25536

Back to AD 87-20-03 R2