Registered aircraft · 22,413

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.

N316EFLibra Air Inc · Las Vegas, NVBuilt 1974 · S/N 28R-7435172 N316MABlue Side Up Inc · Islamorada, FLBuilt 1976 · S/N 32-7640112 N316NDCirrus Aviation Inc · Sarasota, FLBuilt 1974 · S/N 28-7415346 N316VUpstate Sc Flyers LLC · West Union, SCBuilt 1979 · S/N 32-7940027 N316XKinney Shawn M · Camp Verde, AZBuilt 1969 · S/N 28R-35670 N316ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881641 N31700Ratcliff Bruce A · Plain City, OHBuilt 1978 · S/N 32-7840143 N31709Pace Richard · Leighton, ALS/N 32R-7885121 N31715Brereton Mark C · Lineville, ALBuilt 1978 · S/N 28-7816578 N31716Metro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816579 N3171QLynn Aviation LLC · Wilmington, DEBuilt 1977 · S/N 28-7725217 N31721Needler Toby · League City, TXS/N 32R-7885124 N31724Apostolic Fellowship Assoc · Clearwater, FLBuilt 1978 · S/N 32R-7885126 N31734Oscar Air LLC · Bethlehem, PABuilt 1978 · S/N 28R-7837246 N31736Lees Sea Air · Kiana, AKBuilt 1978 · S/N 32-7840145 N31737Scs Construction LLC · Cape May Ch, NJBuilt 1978 · S/N 32-7840146 N31739Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 32R-7885127 N3173QRosner Gary A · Enfield, CTBuilt 1977 · S/N 28-7716140 N3173RRona LLC · Phoenix, AZBuilt 1969 · S/N 28R-31121 N3174RSeifert Richard W · Big Bear City, CAS/N 28R-31122 N31754Idlewild Aviation Inc · Lewes, DEBuilt 1978 · S/N 28-7890478 N3175QMarshaltown Aviation Inc · Marshalltown, IABuilt 1977 · S/N 28-7716141 N3177RLaviano Kenneth J · Westwood, NJBuilt 1969 · S/N 28R-31125 N31795Kshr Av8rs LLC · Sheridan, WYBuilt 1978 · S/N 32R-7887010 N317BFBoldflight LLC · Greenwood, INBuilt 1979 · S/N 28-7990428 N317HMSplendid Aviation-Victoria LLC · Corpus Christi, TXBuilt 1966 · S/N 28-3734 N317LBTrail Of 140 Tears LLC · Bozeman, MTBuilt 1970 · S/N 28-26935 N317NCField Daniel James · Bloomfield, CTS/N 28R-7635439 N317TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020141 N31831Dcoat LLC · Greenlawn, NYBuilt 1978 · S/N 28-7890479 N31841Rotormate LLC · Royse City, TXBuilt 1978 · S/N 32-7840149 N31847Nevada Air Partners LLC · Boulder City, NVS/N 32R-7887011 N31863Dell Air Co LLC · Paterson, NJBuilt 1978 · S/N 28-7890482 N31870Flight Level Aviators LLC · Glendale, AZBuilt 1978 · S/N 28R-7803302 N31871Dodson Randall L · New Hope, MNBuilt 1978 · S/N 32-7840150 N3187QJuliet Whiskey Aviation LLC · Gilbert, AZBuilt 1977 · S/N 28-7790441 N31885It Is Well · Kennett, MOBuilt 1978 · S/N 32-7840152 N3189QBoll Weevil Flyers LLC · Reedville, VABuilt 1977 · S/N 28R-7737049 N318FCMendoza Jeremy · Honolulu, HIS/N 28-25156 N318JMN318jm LLC · Wilmington, DES/N 32R-8313021 N318PKValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887037 N31900Woodward Joseph A Jr · Wshngtn Xing, PABuilt 1978 · S/N 28-7816592 N31905Weishuhn Aviation LLC · Farwell, MIBuilt 1978 · S/N 28-7890484 N31906Bosveld Bobby J · Markesan, WIBuilt 1978 · S/N 28R-7837254 N31916Registered aircraftS/N 32-7840155 N31920Sarasin Stuart P · Au Train, MIS/N 32R-7887015 N31923Metro Aicraft Co · Bloomington, MNBuilt 1978 · S/N 28-7816597 N31926Van Cura Don · Chicago, ILBuilt 1978 · S/N 28-7890486 N31930Patrick Juan Hughes · Hernando, FLBuilt 1978 · S/N 28R-7803305 N31933G & C Flying Inc · Litchfield, ILS/N 32R-7885142

Back to AD 87-08-08 R3