AD 80-01-06
Registered aircraft · 2,130
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:80-01-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:80-01-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:80-01-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:80-01-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.
N170SUTop Flight Consulting LLC · Fort Myers, FLN172BDMurawski Rene · Clarkston, MIN172CESan Diego Community College District · San Diego, CAN172DPSuperior Aviation Gateway LLC · Tampa, FLN172KAVenture North Aviation LLC · Cloquet, MNN172MMEwing & Coryell LLC · Nixa, MON172PESale Reported · Kenmore, WASale reportedN172RGMaxwell Don P II · Longview, TXN172SFTichy Joseph R · Napa, CAN172ZGSouthern Aircraft Consultancy Inc Trustee · Casper, WYN173RGBuchert Christine W · SchweinfurtN176LGTita Enterprises LLC · Apex, NCN177BDHillsboro Aero Academy LLC · Hillsboro, ORN17RRRiverside Flight Center Inc · Tulsa, OKN185SEJensen Aviation Inc · Zephyrhills, FLN185SRHillbilly Holler LLC · Missoula, MTN18HTTobler Niccolo Sunny · Anchorage, AKN191FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILN192FSSouthern Illinois University Board Of Trustees DBA · Murphysboro, ILN197THN197th LLC · Sammamish, WAN2034NNorthstar Aviation Leasing LLC · Merritt Island, FLN20CTN20ctid LLC · Pocatello, IDN20CUCosta Flying Service Inc · Painted Post, NYN212BGRegistered aircraftN212MBEuro 2000 Inc · Merritt Island, FLN216CLMisamore Steven Edward · Mount Juliet, TNN216DVBusch-Joss Elizabeth M · Blue Point, NYN216JARuble Howard L Jr · Spartanburg, SCN218JAWildwood Helicopter Co Inc · Wildwood, NJN218ZMSkylink Xpress Inc · San Bernardino, CAN229DKKoerkenmeier James J · Carlyle, ILN22JNRegistered aircraftN230SVSwailes Craig · Taylor, MIN233SHSieger Aviation Services Inc · Bismarck, NDN240SUOhio State University · Columbus, OHN24214Mckinney Brett A · Hackleburg, ALN24242Fly Sky Ads LLC · Manalapan, NJN24260Aerial Banners Inc · Pembroke Pines, FLN24261Citabria Inc · Auburn, CAN24264Sunrise Aviation Inc · Ormond Beach, FLN24266Hillsboro Aero Academy LLC · Hillsboro, ORN24269Sioux Air Inc · South Sioux City, NEN24296Cc Aviation Inc · Tracy, CAN24305Woolsey Joseph A · Squaw Valley, CAN24313Wings Over Texas Holdings LLC · Denton, TXN24315Cubicle Concepts Inc · New Holland, PAN24327Centurion Aviation · Salina, KSFirst renewal noticeN24331Registration Pending · Norman, OKRegistration pendingN24333Silver Express Co DBA · Miami, FLN24351426th Aero Squadron LLC · Cropwell, AL
Back to AD 80-01-06