AD 46-40-01
Registered aircraft · 188
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
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-40-01')
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-40-01')
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-40-01') 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-40-01') 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.
N81221Hamilton Steven T · Carson City, NVN81226Felda Flyers LLC · Felda, FLN81228Hagerstown Aviation Museum Inc · Hagerstown, MDN81230Wyman Corwyn W · Columbia Falls, MTN81234Haggerty John J Jr · Skaneateles, NYN81241Clemens Russell E · El Cajon, CAN81242Davis Susan J · Castroville, CAN81243Martin Jonathan W · West Grove, PAN81255Egmond Aircraft LLC · Lewes, DEN81270Modlin Clarence T Jr · Dickinson, TXN81276Dowdy John H · Union, WVN81284Registered aircraftN81285Richard D James · Groveland, FLN81292Rice James L · Mckinney, TXN81295American Aviation II LLC · Peyton, CON81306Sale Reported · Seneca, SCSale reportedN81311Eddie Adams · Senath, MON81313Walk Michael · Englewood, FLN81316Branam James G · Middletown, OHN81325Weeks Monte L · Somerset, WIN81326Camp Ted A · Williamson, GAN81329Jenkins James L · Lake Stevens, WAN81330Shank Paul L · Gaithersburg, MDN81331Linn Ronald D · Stanfield, ORN81334Handly William A · Arcola, MSN81338Ferguson Carrie L · Palo Alto, CAN81348American Airpower Heritage Flying Museum · Dallas, TXN81349Dyson Keith A · Port Townsend, WAN81358Ferguson Cris · Livermore, CAN81362Jones Kenneth M · Auburn, CAN81363Alexander Larry A · Kosciusko, MSN81373Webb David B · Wapakoneta, OHN92EPetersen Danny S · Caddo, OKN9384Cournoyer John J · Ellsinore, MON9397Currie Richard W · Woodland, CAN9402HSchulert Philip J · Lebanon, TNFirst renewal noticeN957VRegistration Pending · Oklahoma City, OKRegistration pendingN987Carlsbad Raceway Corp · Hemet, CA
Back to AD 46-40-01