AD 76-06-06
Registered aircraft · 1,247
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:76-06-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:76-06-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:76-06-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:76-06-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.
N2348MSurgent Richard L · Wall Township, NJN2349MMurray Donald L · Two Harbors, MNN2358MGrassley Leonard J · Newport, ORN2361MSutter Tim C · Glennallen, AKN2362MCanfield James R · South Gibson, PAN2364MKissenger Richard G · Centre Hall, PAN2368MOconnor Sarah A · Franklin, WIN2369MBoberg James J · Littleton, CON2376MHuberd Kyle A · Wilsonville, ORN2378MLacher Louis R Jr · Wasilla, AKN2379MThies Trevor H · Seattle, WAN2381MArnold V Charles F · Anchorage, AKN2384MDiedrich Steve · Sandpoint, IDN2385MLucatorto Jeffrey A · Mc Gaheysville, VAN2386MHoeffler James P · Fort Collins, CON2387MOlson Catherine R · Two Rivers, AKN2388MVotaw Kristina M · Anchorage, AKN2393MKahn R Douglas · Boston, MAN2397MBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCN2403MBossie Jeff J · Unity, MEN2404MTodhunter John S · Hemet, CAN2409MNiner Mike LLC · Gonvick, MNN2410MSpicher Samuel C · Harrisonburg, VAN2418MBallow Richard C · Valdez, AKN2428MTyrrell Wesley F · Central, AKN2429MTurner Greg W · Delta Junction, AKN2431MSchroeder John · Anacortes, WAN2432MBunce John · Canaan, CTN2439MRegistered aircraftN2442MRegistration Pending · Sterling, AKRegistration pendingN2444MMerillat Anthony J · Adrian, MIN2446MCondor Aviation LLC · Bethlehem, PAN2450MProlagayev Sergey · Needville, TXN2451MAccurate Aero LLC · Minden, NVN2455MArizona Soaring Inc · Maricopa, AZN2462MPalmenteri Louis J · Rhome, TXN2464MRosenquist Eugene C · Kasilof, AKN2466MDonalds Flying Service Inc · Pantego, NCN2467MToelle Neill · Fairbanks, AKN246ACMateski James C · Salmon, IDN2470MFluckey Gary T · Homer, AKN2472MAufderhar Kenneth G · Lopez Island, WAN2473MMcgahan Jackie L · Kenai, AKN2474MAshe David J · Randle, WAN2475MN B Tweet And Sons · Nome, AKN2477MRegistration Pending · Indianapolis, INRegistration pendingN2483MLanners Thomas P · Chickaloon, AKN2484MRegistered aircraftAssigned, pending cancellationN2485MMason Michael S · Sequim, WAN2486MBartel Christopher H DBA · Williamsburg, PA
Back to AD 76-06-06