AD 2011-13-03
Registered aircraft · 18,048
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:2011-13-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:2011-13-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:2011-13-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:2011-13-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.
N1016TPlane Fun Inc Tr Trustee · Snellville, GAN1016UBlueskys Inc · Wilmington, DEN1016XRadial Holdings LLC · Fort Worth, TXN1017GAustin Byrum Andrew C · Rogers, ARN1017LTop Gun Aviation Inc · Quinnesec, MIN1017MOstroff Nathaniel S · Summerland Key, FLN1018HGulf Air Group Inc · Crestview, FLN101AMLehs Kent · Grimes, IAN101AXFogg Britt · Springdale, ARN101BHMpdkm Inc · Las Vegas, NVN101CEDurocher Alain P · Long Beach, CAN101DHLarson David R · Boerne, TXN101DYDyess Investments LLC · Bassfield, MSN101EEAlaskan Aerial Photography LLC · Anchorage, AKN101GKCramer Keith B · Paso Robles, CAN101LCReading Randall C · Redlands, CAN101LPGranite Boarding LLC · Loomis, CAN101MAPablo Air Charters LLC · New Freedom, PAN101MLWesolowski Trevor · Berkeley, CAN101NEDarby Flying Corp · Homestead, FLN101NWVortex Aircrafts Inc · Port Saint Lucie, FLN101PAKeenan Mark · Chico, CAFirst renewal noticeN101PLHay William G Jr · Gualala, CAN101TKLensing Wayne K · Popular Grove, ILN101TVSky Helicopters Inc · Garland, TXN101UKInternational Air Services Inc Trustee · Carson City, NVN101WCRamey Curtis · Hilton Head Island, SCN101YBCowan Lance E · Watonga, OKN101YTJagt Terrence L · Crestline, CAN1021PYurok Tribe Construction Corp · Klamath, CAN1023XBickley David R · Pocatello, IDN1024LSouthern Aircraft Consultancy Inc Trustee · Casper, WYN10262Davoli Third Family Limited Partnership · Lighthouse Point, FLFirst renewal noticeN1026CMooney Howard James Jr · Lake Wales, FLN1026UMooneylust LLC · Springfield, MON1027FFilarski Darryl M · Grosse Ile, MIN1028GCreed Brian H · Fredericksburg, VAN1028RGarner Donald G · Greeley, CON1029TThomson Heath · Portola Valley, CAN1029XBaden Frederick Richard · Mc Arthur, OHN102DLP & G Trading Co Inc · Trenton, NJN102EASteves Atv Services Inc · Oceano, CAN102JFAble Enterprise LLC · Tampa, FLN102KYPatriot Aviation LLC · Rostraver Township, PAN102TMJunior Fernando Sporleder · Sarasota, FLN102WCDac 2020 Inc · Skaneateles, NYN102WHStuddiford James A · Lithia, FLN102WMStar Air Service LLC · Jacksonville, FLN1030ZLenhart Thomas E · Barnesville, GAN1031RKeller Paul M · Sanford, NC
Back to AD 2011-13-03