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.

N8488ZGlacier Flight LLC · Kalispell, MTBuilt 1963 · S/N 2050488 N84891Bohl Robert M · Williamsburg, OHS/N 17258656 N84896An Aircraft LLC · Springfield, MOBuilt 1969 · S/N 17258658 N84897Independent Aviation Services LLC · Sachse, TXBuilt 1970 · S/N 17258659 N84898Coles County Airport Authority · Mattoon, ILBuilt 1969 · S/N 17258660 N8489LBarlow Warren P · Madison, ALBuilt 1968 · S/N 17256689 N8489MOconnell Timothy Ryan · Davenport, WAS/N 18264627 N8489SReading Michael P · Monee, ILBuilt 1965 · S/N 18256589 N8489TGordon Robert A · North Pole, AKBuilt 1959 · S/N 52389 N8489ZDyer Joe E · Navasota, TXS/N 2050489 N84901Boerne Flight Options LLC · Boerne, TXBuilt 1969 · S/N 17258661 N84907Wang Qiuyuan · Arcadia, CAS/N 17258663 N8490GDodot Daniel A · Westminster, COS/N 15062590 N8490JB&K Holdings LLC · Birmingham, ALBuilt 1967 · S/N 15066390 N8490LMgg Aviation 2025 LLC · Annandale, MNBuilt 1968 · S/N 17256690 N8490MMathison John · Vancouver, WAS/N A15000190 N8490SHerring James N Jr · Nederland, COBuilt 1965 · S/N 18256590 N8490ULemons Mary A · Conner, MTBuilt 1964 · S/N 17252390 N8491GMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 15062591 N8491LDeb Air Inc · Norcross, GABuilt 1968 · S/N 17256691 N8491MHollenbaugh Gerald K · Glenwood Springs, COBuilt 1970 · S/N A1500191 N8491QDry Bay Holdings LLC · Yakutat, AKBuilt 1976 · S/N U20603349 N8491SOgrin Kirk V · Bigfork, MTBuilt 1965 · S/N 18256591 N8491URegistration Pending · Garrettsville, OHRegistration pendingBuilt 1964 · S/N 17252391 N8491XHeauser Mark · Grass Valley, CABuilt 1961 · S/N 17248991 N8491ZBoice Christopher T · Roseburg, ORBuilt 1963 · S/N 205-0491 N8492LCarey Thomas A · Carabaset Vly, MEBuilt 1968 · S/N 17256692 N8492SFlight Testers LLC · Seattle, WABuilt 1965 · S/N 18256592 N8493LBriss David S Dmd · Somerset, NJBuilt 1968 · S/N 17256693 N8493MValiair Lc Trustee · Casper, WYBuilt 1976 · S/N 18264629 N8493XDavis Michael L · Rowland, NCBuilt 1961 · S/N 17248993 N8494GReynolds Terry J · Phoenix, AZBuilt 1965 · S/N 15062594 N8494LHess Garrett · Fullerton, CABuilt 1968 · S/N 17256694 N8494MCardinal Sg LLC · Mukilteo, WABuilt 1976 · S/N 18264630 N8494URieck Brian M · Junction, TXBuilt 1976 · S/N 15077940 N8495GCorrigan John P · Denver, COBuilt 1965 · S/N 15062595 N8495JParks Ryan Alan · Newcastle, WYBuilt 1967 · S/N 15066395 N8495MCourtney Aviation LLC · Columbia, CAS/N 21062048 N8495TCullom Mitchell T · Anchorage, AKBuilt 1959 · S/N 52395 N8495XRomeoromeo Alpha LLC · Greensburg, INBuilt 1961 · S/N 17248995 N8496QWord Forrest R Trustee · New Braunfels, TXBuilt 1976 · S/N U20603354 N8496SOkon Randy W · Missoula, MTBuilt 1965 · S/N 18256596 N8496UChandler Donald M · Alexandria, LABuilt 1964 · S/N 17252396 N8496XR & R Flight Services LLC · Orange Grove, TXBuilt 1961 · S/N 17248996 N8496ZRegistered aircraftS/N 205-0496 N8497GDeacon Jeffrey A · Battle Ground, WABuilt 1965 · S/N 15062597 N8497MWenatchee Valley Barnstormers LLC · Wenatchee, WABuilt 1970 · S/N A1500197 N8497URawlins Flying Club Inc · Rawlins, WYBuilt 1964 · S/N 17252397 N8497XConnors James R · Manchester, MIBuilt 1961 · S/N 17248997 N8498LWestern Slope Aviators LLC · Delta, COBuilt 1968 · S/N 17256698

Back to AD 87-20-03 R2