AD 46-36-01
Registered aircraft · 9,759
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-36-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-36-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-36-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-36-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.
N110KSink Lendon V · Lexington, NCN110TCKerzen Properties LLC · Fayetteville, ARN110WPNess David A · Minneapolis, MNN1112ESavage David E · American Falls, IDN1112KDaphna Inc · Middletown, DEN1113VArmentrout Rupert M · Goode, VAN1115ER A Marsh Flying Club LLC · Williamson, GAN11162Tymczyszyn William P · Torrance, CAN1116BRogers Douglas M · Milwaukee, WIN1116KSexton Robert D · Sugar Grove, VAN1117ALillie David W · Galesburg, ILN1117BAnderson Marlin R · Malta, ILN11190Claire Aviation Inc · Wilmington, DEN111EJHague Dana M · Clinton, CTN111VTThovson Virgil D · Ellensburg, WAN1120EMoore Michael L · Gilbert, SCN1125BHansen Michael L · Williamson, GAN1126KBrushwitz Ronald C Jr · Salem, ILN1127ESult David M · Maxwell, IAN1128EEason Timothy D · Fort Worth, TXN1128KMitchell Peter J · Concord, CAN1129VCarolina Flying Machines LLC · Davidson, NCN112AWJones Walter G · Nottingham, PAN112RBLowers Jamesson B II · Little Hocking, OHN1131BBurnett Ronald L · Dardenne Prairie, MON1132BHager Bill E · Parma, IDN1132ENowling Daniel C · Holt, FLN1134EWiley Calvin · Summer Shade, KYN1134VJohnson Gustav M · Newton, NJN1135EFour M Aviation LLC · Clinton, CTN1136BLambasio Francis T · Canton, ILN1136ESale Reported · Butte Valley, CASale reportedN1137BReed Jimmy A · Big Cabin, OKN1137KSelf Edwin C · Columbia, TNN1138DJohnson Benjamin M · Monroe, WIN1139BJohnston Lance M · Bellingham, WAN1139KClairday Joey · Melbourne, ARN113MLCastello Branco Pablo · Montclair, NJN1140BFisher F Louise · Three Rivers, CAN1141JRichardson David D · Woodbury, TNN1141VHampton Flying Services LLC · Portsmouth, NHN1142BWood Ross H · Stuttgart, ARN1142EHenderson Joseph C IV · Midlothian, VAN1144EBuergel Sandra J · East Aurora, NYN1145HFritz Ronald C · Kent City, MIN1146EMj Consulting Inc · Parsons, KSN1147KYoung Frank M · Lompoc, CAN1148EDb Airfreight Inc · Wake Forest, NCN114GNMelau Jeffery B · Rhinelander, WIN1150KLinscheid Glen A · Tillamook, OR
Back to AD 46-36-01