Registered aircraft · 27

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:46-04-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-04-02') 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:46-04-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-04-02')
  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:46-04-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-04-02')
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.

N101BNHigh Alpha Airshows LLC · Camarillo, CAS/N 305 N20988Registration Pending · Oklahoma City, OKRegistration pendingBuilt 1940 · S/N 117 N24RPlane Fun Inc Tr Trustee · Snellville, GABuilt 1940 · S/N 186 N281WRezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1940 · S/N 106 N29250Wingnut Inc · Wilmington, DEBuilt 1940 · S/N 118 N29252Rule Paul Crane Trustee · Wapato, WAS/N 120 N29258Rule Paul Crane Trustee · Wapato, WABuilt 1940 · S/N 126 N29272Rezich & Rezich Aviation Consulting Inc · Winnebago, ILBuilt 1940 · S/N 141 N29273Nimmons Johnny F · Brookshire, TXBuilt 1940 · S/N 142 N29283Jorgensen Bryan H · Wadsworth, OHBuilt 1940 · S/N 152 N29288Kluver Richard L · Three Lakes, WIS/N 157 N29295Hudgin Louis B · Gilbert, AZS/N 164 N29298Sindlinger Lyle J · Puyallup, WABuilt 1940 · S/N 167 N29385Szostak Edward M · San Diego, CABuilt 1940 · S/N 174 N29392Willis Nelson W · Lebanon, TNBuilt 1940 · S/N 184 N29396Jilek Dominic A · River Falls, WIBuilt 1940 · S/N 189 N29398Somes Jason S · Santa Rosa Valley, CAS/N 191 N32471Braddock James W · Nevada City, CABuilt 1941 · S/N 203 N32476Currie Mark H · Justin, TXS/N 208 N32484Giltner Sam · Gilbert, SCBuilt 1941 · S/N 216 N34776Eckberg Robert K · Dakota City, IABuilt 1941 · S/N 230 N34785Western Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1941 · S/N 236 N34791Hays James B · Early, TXBuilt 1941 · S/N 243 N34854Rule Paul Crane Trustee · Wapato, WABuilt 1941 · S/N 262 N37818Lovett Brett E · Liberty, MOBuilt 1941 · S/N 329 N37826Currie Mark H · Justin, TXBuilt 1941 · S/N 331 N41725Airpower Museum Inc · Ottumwa, IABuilt 1942 · S/N 443

Back to AD 46-04-02