AD 75-18-06
Registered aircraft · 212
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-18-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-18-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-18-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-18-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.
N74084Boger Roger · Ludington, MIN74120Slevin Mary Elizebeth · Altamont, NYN74124Bowles Alan B · Georgetown, TXN74822Nockair Inc · Longboat Key, FLN74823Tobler Hans P · Anchorage, AKN74898James David R · Wayne, MIN755ELavanture Richard A · Bristol, INN7730Gay Richard L · Middleville, MIN7732South Atlanta Helicopters LLC · Hampton, GAN7736Shank Brian · Manheim, PAN7762Peterson Chester L · Spring, TXN7802EContinental Helicopters Inc · Mason, TXN7887BLidija LLC · Grass Valley, CAN7888BMorten David J · Larimore, NDN78900Master Designs LLC · Gilbert, AZN7893BDykstra Donald J · Dorr, MIN7985AGiles Forrest D · Springtown, TXN7ARAircraft Sales LLC · Caledonia, MIN8051EPatterson Casey Paul · Kinston, ALN80SQWatkins Arlo S · Chandler, AZN8117Henry Mark A · Dickinson, TXN8236Horey Scott R · Ione, CAN8403EChurchill Scott W · Le Sueur, MNN8409ED'Agostino Gerald J · Middleburg Hts, OHN8428EWheatley Lester Edward Jr · Woodcrest, CAN8441EShore Stephen A · Elkin, NCN8478DWood Denton A · Friendswood, TXN8478HBertiling Brad · North Shore, CAN8520HVegas Baby! Lc · Royal Oak, MIN855ETobler Hans P · Anchorage, AKN8645GTobler Hans P · Anchorage, AKN88754Skypro Industries Inc · Jacksonville, FLN88755Old Time Ag Aviation LLC · Bakersfield, CAN88ARLumley William B · Delray Beach, FLN8975Gauntlett Robert Michael · Yukon, OKN9025Ocean Air Inc · Eugene, ORN903BCosta James J · Tulare, CAN90520Vanderbie Mark A · Hudsonville, MIN90529Northland Helicopters Inc · Le Sueur, MNN908BPlevyak Malcolm S · Berwick, PAN9115ROlson Robert L · Yuba City, CAN9158RHaley Lee · Ahwahnee, CAN917BQuatacker Matt · Porterville, CAN921BAdkins Dwain L · Sycamore, ILN929BValiant Air Command Inc · Titusville, FLN93067Milam Inc · Trussville, ALN93175Gottschalk Brian D · Moscow, IDN932BCox William H Jr · Vacaville, CAN9421HElliott Miles DBA · Porterville, CAN950BIgwt Helicopters · Williford, AR
Back to AD 75-18-06