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-37-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-37-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-37-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-37-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-37-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-37-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.

N2225MBerry Darrel · Camden, TNBuilt 1946 · S/N 21017 N23409Miller Harrison · Hallsville, MOS/N 3144 N25730Orton Aviation LLC · Walker, MNBuilt 1940 · S/N 3690 N30766Scotton Bradley D · Galena, AKBuilt 1940 · S/N 5098 N32673Autry Lonnie E · San Jose, CABuilt 1940 · S/N 5532 N32955Finn Kathryn L K · Grand Marais, MNS/N 5739 N3316NBender Dennis R · Johnson, VTBuilt 1946 · S/N 22515 N35499Turner David · Frenchtown, NJBuilt 1941 · S/N 6404 N3574WOrton Aviation LLC · Walker, MNBuilt 1946 · S/N 18159 N3613KSorenson Kenneth G · Waller, TXBuilt 1946 · S/N 22301 N42644Wingnut Inc · Wilmington, DEBuilt 1945 · S/N 14935 N49500Chain Steven R · Cottonwood, CABuilt 1942 · S/N G-3 N70272Roussopoulos Gary L · Santa Cruz, CABuilt 1946 · S/N 17253 N70274Two Rays LLC · Charleston, MSBuilt 1941 · S/N 17255 N70661Reed Conrad H · Centre, ALS/N 17681 N70897International Air Services Inc Trustee · Carson City, NVS/N 17984 N70914Schumacher Bradley R · Elma, NYBuilt 1946 · S/N 17934 N71014Hofmann John M · Columbus, WIBuilt 1946 · S/N 18030 N88151Waterlanding LLC · Missoula, MTBuilt 1946 · S/N 15768 N91943Clark Henry F Jr · Fort Edward, NYBuilt 1946 · S/N 16363 N92044Lear Eric T · Tomahawk, WIBuilt 1946 · S/N 16477 N92167Yedowitz Michael C · New Milford, CTS/N 16699 N92620Goodrich Jeffrey W · Slaton, TXBuilt 1946 · S/N 16983 N98701Fandler Frederick E · Denton, TXBuilt 1946 · S/N 18931 N98729Aviation Consultants Inc · Newton, NJS/N 18957 N98762Fowler Matthew S · Austin, TXBuilt 1946 · S/N 18995 N98864Williams Francis B III · Meridian, GABuilt 1946 · S/N 19126

Back to AD 46-37-02