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.

N210LTAlta Pump Co Inc · Reedley, CABuilt 1980 · S/N 21064535 N210LXColeman Daniel N · Phoenix, AZBuilt 1972 · S/N 21059720 N210MRegistered aircraftBuilt 1976 · S/N 21061600 N210MDAvmax Aviation LLC · Wilmington, DEBuilt 1984 · S/N 21064827 N210MESouther Field Aviation Inc · Americus, GAS/N 21061123 N210MFCollins Caryl A · Westcliffe, COBuilt 1978 · S/N P21000105 N210MMMarble Aviation LLC · Ball Ground, GABuilt 1971 · S/N 21059491 N210MPFranklin Robert · Castro Valley, CABuilt 1979 · S/N 21063193 N210MSDahl Gustave C · Washington, ILBuilt 1979 · S/N 21063411 N210MTWaistcat Aviation Inc · Mcallen, TXBuilt 1981 · S/N 21064165 N210MYIts Always Something LLC · Winter Haven, FLBuilt 1977 · S/N 21061763 N210NBurton Stone LLC · Durango, COBuilt 1969 · S/N 21059102 N210NHMoore John R · Acworth, GABuilt 1972 · S/N 21059565 N210NLSsd2 LLC · Napa, CABuilt 1981 · S/N P21000674 N210NMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 21059255 N210NPDocflyers LLC · Leesburg, FLBuilt 1974 · S/N 21060436 N210NSNovember Sierra Aviation LLC · Oneill, NEBuilt 1960 · S/N 21057595 N210P210p LLC · Kalispell, MTBuilt 1981 · S/N 21064500 N210PATrejo Nahomy · Socorro, TXBuilt 1980 · S/N 21064088 N210PCDiaz Ricardo · North Miami, FLBuilt 1978 · S/N 21062801 N210PEVan Dyke Gary D · Pleasant Grove, CABuilt 1969 · S/N 21059180 N210PJNickels Raymond E · Loxahatchee, FLBuilt 1979 · S/N 21063446 N210PKBeam Construction Nv LLC · Zephyr Cove, NVBuilt 1979 · S/N 21063455 N210PLMts Inc · Middletown, DEBuilt 1978 · S/N 21062528 N210PPPapaco LLC · Green Cove Springs, FLBuilt 1978 · S/N P21000100 N210PRShaw Ronald V · Edmond, OKS/N 64883 N210PWPapa Whiskey Aviation LLC · Huntsville, ALBuilt 1981 · S/N 21064343 N210PZKmz Centurion LLC · San Mateo, CABuilt 1976 · S/N 21061268 N210RBLibrary Interiors Of Florida Inc · Auburndale, FLBuilt 1982 · S/N 21064716 N210RDPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000772 N210REValiair Lc Trustee · Casper, WYS/N P21000846 N210RPRegistration Pending · Charlestown, INRegistration pendingBuilt 1978 · S/N P21000014 N210RRBeasley Emmett C · Bixby, OKBuilt 1960 · S/N 57503 N210RSInternational Air Services Inc Trustee · Carson City, NVS/N P21000147 N210RZKk Hangar LLC · Little Rock, ARBuilt 1971 · S/N 21059529 N210SBLofshult John C · Sloan, IAS/N 18799 N210SCSpence C Jason · New Braunfels, TXBuilt 1967 · S/N 21058888 N210SDArdoin Robin C · Lafayette, LABuilt 1980 · S/N 21064225 N210SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N P21000621 N210SLKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N P21000129 N210SMMcconnell Peter · Valencia, PABuilt 1979 · S/N P21000370 N210SNDominguez Mark J · Many, LABuilt 1980 · S/N P21000548 N210SSVucich Bryant · Palm Beach Gardens, FLBuilt 1978 · S/N 21062997 N210SVBevis Richard L · Middletown, OHBuilt 1978 · S/N 17271361 N210SWSierra Whiskey Aircraft LLC · Saint Louis, MOBuilt 1975 · S/N 21061068 N210SYBluegrass Air Systems LLC · Nicholasville, KYBuilt 1979 · S/N 21063684 N210TRichard Brady K · Farmers Branch, TXBuilt 1978 · S/N 21062936 N210TBGurnee Steven H · Granite Bay, CAS/N 21063561 N210TECenturion Flyers LLC · Crystal Bay, NVBuilt 1975 · S/N 210-60544 N210TFAll About The Doodles Inc · Kirkland, ILS/N 21057793

Back to AD 87-20-03 R2