AD 2001-23-03
Registered aircraft · 5,350
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:2001-23-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-23-03')
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:2001-23-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-23-03') 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.
N1100UThomas Jennifer G · Dayton, OHN110RJMathias Ralph · Long Beach, CAN111EXNew Orleans Aviation LLC · Covington, LAN111HPFlying Aces Aero-Fleet Inc · Guyton, GAN111HVBga-Viation · Bennettsville, SCN111LHSuperior Aviation Gateway LLC · Tampa, FLN111ZYSkywarrior Flight Training Inc · Pensacola, FLN1135FLong Duane C · Baskin, LAN1147VRegistration Pending · Moore, OKRegistration pendingN114FAJprg Aviation Inc · Orlando, FLN114WPUniversal Aviators Academy Inc · El Monte, CAN1152VGolden Eagle Consulting LLC · Williston, NDN1157VJohnson Lisa Nicole · Klamath Falls, ORN1159VShular Rodger D · Antelope, CAN1163FMid-Tenn Aero Club Inc · Franklin, TNN1166VClark John A · Windsor, CAN1167VBoard David N · Woodsfield, OHN1168VGood Guys Flying Club LLC · Colorado Springs, CON116FPRandall David J · Balsam Lake, WIN1170VPadgett Keith A · Bow, WAN117ABHellickson Brad · Corona, CAN117JBGenerations Flying Club LLC · Washington, MON117PBLadue Scott B · Fate, TXN117RCMaresh Jeremiah · Redding, CAN117WTFly Whiskey Tango LLC · Scottsdale, AZN1185FClements Michael R · Gig Harbor, WAN118PCCarenbauer Paul J · Hernando, FLN1193FVoss Douglas D · Grand Island, NEN1197VVentry Solutions Inc · Hauser, IDN119DCDuque Helen · Orlando, FLN119FRJeffery & Weiss Holdings LLC · Long Beach, CAN11MBYoungstown Warren Development Partners · Youngstown, OHN1200USowers Harry D · S Bloomingvle, OHN1201FRed Door Aviation LLC · Dover, DEN1203FRawson Aviation LLC · Collinsville, OKN1213FFlight Answers LLC · Miami Lakes, FLN1216VKingdom Air Corps Inc · Sutton, AKN121MSDarcy Aviation LLC · Danbury, CTN1221VLovely John E · Rich Creek, VAN1226FSnoopys Group Inc · Westerly, RIN122MJHyper Flight Inc · Seattle, WAN122XPWatch Ya Head Aviation 1 LLC · Zionsville, INN1233VFlybuy Investments LLC · Natchitoches, LAN123GJAftcloud Inc · Ontario, CAN123KSKingsky Flight Academy LLC · Lakeland, FLN123MBSpinner Family Lp · White City, ORN123TTMidwest Athletic Supply LLC · San Marcos, CAN123UCDavenport Jeffery W · Meadowview, VAN1240VHeink Philip · Lexington, KYN1243VAlexander Arlene Myers · Sandwich, MA
Back to AD 2001-23-03