AD 75-09-06
Registered aircraft · 1,624
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:75-09-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-06')
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:75-09-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-06') 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.
N119DSDeltasierra LLC · Staunton, VAN11ATChan Roger J · Anchorage, AKN11CSilicz Nicholas J · Shafter, CAN11CEMelcher Pierre S · New Braunfels, TXN1204FMoroney Aviation LLC · Chugiak, AKN1206FHarrah Daniel R · Juneau, AKN1208FYukon Air Service Inc · Fairbanks, AKN1211FGarner Greg A · Renton, WAN1217FUnited States Department Of Interior · Boise, IDN121EESheldon Air Service LLC · Anchorage, AKN1222FVelocity Sport LLC · Cedar Falls, IAN1225QDupont Larry W · North Hero, VTN1227FPeterson Investments Inc · Polson, MTN122VCTurner Terrance A · Anchorage, AKN1231FRegistration Pending · Wasilla, AKRegistration pendingN1232FLloyd Land Plane I LLC · Brighton, CON1234YDe Jong Thomas · Buckeye, AZN1236FPitcher Michael C · Mancelona, MIN1237Fraser Mark L · Fairfield, CAN1239FValpey R Wesley Jr · Medford, MEN123EPFalkenberg Randy J · Edmonson, TXN124LRWilson David J · Palmer, AKN124UAKagerer John A Trustee · Anchorage, AKN1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKN125KTRustair Inc · Anchorage, AKN1282FRainbow River Lodge Aviation LLC · Alpine, UTN1285FWill Rittner E · Sevierville, TNN1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeN1292FRustair Inc · Anchorage, AKN1296FWalker Brandon · Anchorage, AKN129KTFowler Andy D · Anchorage, AKN129LPJag Aviation LLC · Belle Chasse, LAN129MLarkin Marion J · Salome, AZN129PRRasmussen Paul B · Long Lake, NYN12ASNewman Scott W · Healdsburg, CAN12DMIsland Airways LLC · Marion, WIN1322FHoffman Michael J · Bethel, AKN135NCBalocco Mark E · Sparks, NVN1362FOldham Kris D · Anchorage, AKN1370QEvans Randall B Trustee · Fallon, NVN1373FBaczewski Gary L · San Antonio, TXN137LKStubby Wings LLC · Eden Prairie, MNN1393FBenham John D · Blanco, TXN13WSJohnson Chad H · Houston, TXN13WWHurd Steven C · Bangor, MEN1431EBrandt Terry R · Hood River, ORN143HJHurlburt Ward B IV · Anchorage, AKN1467FJetceo LLC · Kalispell, MTN1469FSkywagon 185 LLC · Ocala, FLN1470QHillyer Joe F · Soldotna, AK
Back to AD 75-09-06