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.

N65994Christiansen Aviation LLC · Wilmington, DEBuilt 1983 · S/N 17275942 N65997Dalton John C · Hernando, MSBuilt 1974 · S/N 15075764 N65999Vaughn Thomas N · Shallowater, TXBuilt 1977 · S/N 18052903 N6599DBlue Shield Aviation LLC · Saint Petersburg, FLBuilt 1979 · S/N 17272886 N6599FSiebe James E · Moscow, IDBuilt 1966 · S/N 15063199 N6599MSieben Livestock Co · Helena, MTS/N 18263773 N659BPArnold Airplane LLC · North Branch, MNBuilt 1975 · S/N 18263560 N659SDCall David A · Carson City, NVBuilt 1956 · S/N 33897 N65AMDorroh Frederick A · Ardmore, OKBuilt 1968 · S/N 18259022 N65BBHoogasian Stephen M · Manassas, VABuilt 1948 · S/N 18244 N65CFSanders David T · Flagstaff, AZBuilt 1962 · S/N 18254365 N65DGDeschweinitz Christian R · Anchorage, AKBuilt 1954 · S/N 26210 N65DPPilawski Darren · Spring Hill, FLS/N 17257299 N65DWNorth Stream Capital LLC · Scottsdale, AZBuilt 1969 · S/N 18052026 N65EAPhilbrick Quinn R · Rangeley, MEBuilt 1966 · S/N 1850997 N65EBKansas Farm & Ranch In · Seneca, KSBuilt 1977 · S/N R1722331 N65GVDemski Domenic Ross · Woodbridge, CAS/N 17271252 N65JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1977 · S/N 17268591 N65JXFlight World Inc · San Juan, PRBuilt 1980 · S/N 15284244 N65KDNorthwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 17264565 N65KSSauceda Juan B · Austin, TXBuilt 1965 · S/N 18256481 N65MArata Steve · Corning, CABuilt 1965 · S/N 15061421 N65MMShewbart Keith M · Crystal River, FLBuilt 1969 · S/N 337M0446 N65MPWard Gerald · Austin, TXS/N 21057904 N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729 N65PKOlson'S Excavating Inc · Cascade, IDBuilt 1966 · S/N 18257491 N65PTBs Aviation LLC · Portland, ORBuilt 1976 · S/N 177RG1086 N65RGRandolph Clinton A · Bullhead City, AZBuilt 1965 · S/N 15061365 N65RHHall Robert · Rapid City, SDBuilt 1977 · S/N 18052869 N65SKenyon Ray · Sherburne, NYBuilt 1974 · S/N P3370166 N65SUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1968 · S/N 0496 N65WBMckamey Robert S · Tullahoma, TNBuilt 1966 · S/N 17254426 N65WPWarnken James V · Pleasanton, TXBuilt 1977 · S/N R1722232 N66003Nesheim William A · Holderness, NHBuilt 1979 · S/N R1723000 N66006Registration Pending · Souderton, PARegistration pendingBuilt 1974 · S/N 15075769 N66009Cowan Ronnie C · Glasgow, KYBuilt 1974 · S/N 15075772 N6600DMarsh John E · Washington, DCS/N 15072100 N6600FSeiger Thomas W · Medford, ORS/N 15063200 N6600RDoyles Welding Lc · Phillipsburg, KSBuilt 1979 · S/N 172RG0206 N6600TJtf Aviation LLC · River Falls, WIBuilt 1962 · S/N 17249906 N6600XBlanton David L · Valley Center, KSBuilt 1960 · S/N 21057600 N66015Rock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 17275948 N66017Engelhardt John · Kingwood, TXFirst renewal noticeBuilt 1974 · S/N 15075778 N66018Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17275949 N6601EBiloff Chet A · Palmer, AKBuilt 1959 · S/N 56101 N6601HCanby Pilots Club Inc · Canby, MNBuilt 1975 · S/N 17265503 N6601KAir Force Academy Aero Club · Usaf Academy, COBuilt 1980 · S/N 17274218 N6601MOptical Aviation LLC · Edmond, OKBuilt 1975 · S/N 18263774 N6601RHolmes Donald R · Carlsbad, CABuilt 1979 · S/N 172RG0207 N66021Mcgraw Leasing LLC · Sitka, AKBuilt 1977 · S/N 18052905

Back to AD 87-20-03 R2