AD 83-22-06
Registered aircraft · 11,722
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:83-22-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:83-22-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:83-22-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:83-22-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.
N115CFFlying C Leasing · Wilmington, DEN115SSSoutheastern Oklahoma State University · Durant, OKN1163FMid-Tenn Aero Club Inc · Franklin, TNN1166VClark John A · Windsor, CAN1167VBoard David N · Woodsfield, OHN1168VGood Guys Flying Club LLC · Colorado Springs, CON1169QRohde Allen G · Eagle River, AKN116AHRegistered aircraftN116FPRandall David J · Balsam Lake, WIN116HRRedpaw Aviation Ltd · Upper Arlington, OHN116SUBoolean Flight Sciences LLC · Mercer Island, WAN1170VPadgett Keith A · Bow, WAN117ABHellickson Brad · Corona, CAN117JBGenerations Flying Club LLC · Washington, MON117PBLadue Scott B · Fate, TXN117PHR & R Leasing LLC · Fargo, NDN117RCMaresh Jeremiah · Redding, CAN117TTMustang LLC · Wilsonville, ORFirst renewal noticeN117WTFly Whiskey Tango LLC · Scottsdale, AZN1185FClements Michael R · Gig Harbor, WAN1188NLll Aviation LLC · Durango, CON11896Mcginty Flying Service LLC · Jones, LAN118ARegistration Pending · Shasta, CARegistration pendingN118HRDieschbourg Thomas Arthur · Glenview, ILN118PCCarenbauer Paul J · Hernando, FLN118SCLeathers Charles M · Silverthorne, CON118SGWilt Jared · Gardners, PAN1193FVoss Douglas D · Grand Island, NEN1196DAerobat Aoa LLC · Wilmington, DEN1197FSchumacher Bradley M · Lewiston, IDN1197VVentry Solutions Inc · Hauser, IDN119DCDuque Helen · Orlando, FLN119DSDeltasierra LLC · Staunton, VAN119FRJeffery & Weiss Holdings LLC · Long Beach, CAN11ATChan Roger J · Anchorage, AKN11CSilicz Nicholas J · Shafter, CAN11CEMelcher Pierre S · New Braunfels, TXN11DHRegistered aircraftN11MBYoungstown Warren Development Partners · Youngstown, OHN11VYPritt Brian C · San Luis Obispo, CAN11YJCrawley Frederick J · Virginia City, NVN1200USowers Harry D · S Bloomingvle, OHN1201FRed Door Aviation LLC · Dover, DEN1203FRawson Aviation LLC · Collinsville, OKN1204FMoroney Aviation LLC · Chugiak, AKN1206FHarrah Daniel R · Juneau, AKN1208FYukon Air Service Inc · Fairbanks, AKN1211FGarner Greg A · Renton, WAN1213FFlight Answers LLC · Miami Lakes, FLN1216VKingdom Air Corps Inc · Sutton, AK
Back to AD 83-22-06