Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N8413WHollier Gregory J · Arnaudville, LABuilt 1965 · S/N 28-2637 N8414CInternational Flying Club Inc · Winfield, ILBuilt 1976 · S/N 28R-7635160 N8414FPenley Robert G · Corinth, TXBuilt 1976 · S/N 28-7725111 N8414M8414m LLC · Nunica, MIBuilt 1981 · S/N 28-8190276 N8414NAirlake Aero Inc · Lakeville, MNBuilt 1981 · S/N 28-8190278 N8414RVick Justin M · Morton Grove, ILBuilt 1966 · S/N 28-22291 N8414WOhmacht Carlton J · Glenwood, MNBuilt 1965 · S/N 28-2638 N8414YLone Oak Aviation LLC · Greenville, NCBuilt 1981 · S/N 28-8190279 N8414ZCunningham Stanley A · New Braunfels, TXBuilt 1981 · S/N 28-8111082 N8415FGrediagin Wayne · Anchorage, AKBuilt 1981 · S/N 32R-8113088 N8415HAeronautica Aviation Inc · Port Orange, FLBuilt 1981 · S/N 32R-8113092 N8415RMahanna John A · Radcliff, KYBuilt 1966 · S/N 28-22348 N8416K8090 Alpha LLC · Grayslake, ILBuilt 1981 · S/N 32R-8113093 N8416RExpert Staffing West Inc · Ramona, CABuilt 1966 · S/N 28-22293 N8416WCass Aviation LLC · North Las Vegas, NVBuilt 1965 · S/N 28-2642 N84175Paris Air Inc · Vero Beach, FLS/N 288116274 N84176Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8116275 N8417CDolan Joseph B · Baltimore, MDBuilt 1976 · S/N 28-7625114 N84180Norris Christopher B · Verona, NJS/N 28R-8131171 N8418CWingman Aircraft Repair Inc · Lawrenceville, GABuilt 1976 · S/N 28-7615106 N8418ETri-State Waterstoppers LLC · Ruffs Dale, PABuilt 1981 · S/N 28-8111083 N8418HFuentes Perez Adriana M · Zelienople, PAS/N 28R-8131169 N8418RCarlsson Carl J · Mason City, IABuilt 1966 · S/N 28-22295 N8418WMadison Mike · Pittsburg, TXBuilt 1965 · S/N 28-2644 N8419CMarsh Geoffrey E · Old Lyme, CTBuilt 1976 · S/N 28-7615107 N8419HHoke William Jr · Charlestown, INBuilt 1981 · S/N 28-8190291 N8419RLytle Cole · North Palm Beach, FLS/N 28-22296 N841ADCedar Real Estate Inc · Anaheim, CABuilt 1973 · S/N 32-7340079 N841ATLuxury Transportation LLC · Talladega, ALBuilt 2004 · S/N 3257352 N841BKKilpatrick Joseph C · Atlanta, GABuilt 1966 · S/N 28-3255 N841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeBuilt 1969 · S/N 28-5488 N841EDR&D Aviation LLC · Fayetteville, GABuilt 1967 · S/N 28-4273 N841NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881308 N841WBQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 32R-7887075 N8420CRegistered aircraftBuilt 1976 · S/N 28-7690138 N8420RMueller Lance · Milton, DEBuilt 1966 · S/N 28-22349 N8420WMckee Shane D · Fairbanks, AKS/N 28-2647 N8421AKing Air Inc · Naknek, AKBuilt 1981 · S/N 32-8106085 N8421RRoberts Darren C · Zionsville, INBuilt 1966 · S/N 28-22298 N84227Jernigan Alex E · Warrensburg, MOBuilt 1981 · S/N 28-8190298 N8422HDeevers Howard A · Tucson, AZBuilt 1981 · S/N 28-8116292 N8422MDymond Mark S · Monterey, TNBuilt 1975 · S/N 28R-7535225 N8422NCenter Flying Inc · Lancaster, CABuilt 1981 · S/N 28-8190296 N8422RTascarella William M · Quakertown, PABuilt 1966 · S/N 28-22299 N8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXBuilt 1965 · S/N 28-2649 N84235Klj Air LLC · Fairless Hills, PABuilt 1981 · S/N 32R-8113098 N8423AWinningham Artis R · Crossville, TNS/N 28-8190299 N8423HSale Reported · Greeley, COSale reportedBuilt 1981 · S/N 28R-8131190 N8423MBrown Rodney E · Nixa, MOBuilt 1981 · S/N 28R-8131191 N8423PAdams Mark · Sumter, SCBuilt 1981 · S/N 32-8106086

Back to AD 87-08-08 R3