AD 2011-26-07
Registered aircraft · 13,298
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-26-07')
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-26-07')
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-26-07') 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-26-07') 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.
N102WLBoyd Stanley E · Placitas, NMN1031HHardy John R · Wasilla, AKN1031RKeller Paul M · Sanford, NCN1032VMatlock Jimmy R · Granbury, TXN1034HBuergel Sandra J · East Aurora, NYN1035HKnapp Louis L · Fairbanks, AKN103ALJordan John S · Sullivan, MON103ERR & J Aviation LLC · Bloomfield Hills, MIN103GSDuce Phillip N · Kotzebue, AKN1040VWilliamson Peter D · Houston, TXN1041GN1041g LLC · Charlotte, NCN10433Sodak Angus Inc · Reva, SDN1047AHolt Sheet Metal Inc · Durango, CON1047QTaras Brock DBA · Cedaredge, CON1048HBeuschel Timothy W · Mount Pleasant, WIN1049DChihuahua Airport Partners Lp · Plano, TXN1049HSavage David E · American Falls, IDN104DBPryce Gerald · Independence, ORN104JHDouble Helix Solutions LLC · Kamuela, HIN104WPMartyn Christian A · Hallendale, FLN104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIN1051HPoulter John W · Sharpsburg, GAN1052HFay Bernard E · Eagle, AKN1054FGilson Gareth F · Phoenix, AZN1054VNorthington Neill · Fredericksburg, TXN1054XMurphy George E · Robinson, ILN1055HReddell Justin · Jasper, ARN1055VWarner Alan P · Carpinteria, CAN1058VPelfrey Earl T · Crossville, TNN105RDSunny Slope Aviation LLC · Adams, TNN1060HJohnston Jeffery A · Eagle River, AKN1064VHenderson Robert J · Grass Lake, MIN1067HAmerell Kathryn · Wasilla, AKN10691Reed Kerr Aviation Inc · Wilmington, DEN1069JLoomis Adra A · Weldona, CON1069VSmith Robert E · Nacogdoches, TXN106CDAerou LLC · Oviedo, FLN106LUBluewater Plumbing Service LLC · Wilmington, NCN106PKScarbrough Dean C · Deshler, OHN106QIntegrity Aero LLC · Boerne, TXN106WSMarriott Ed · Manhattan Beach, CAN1070HGeary Charles L · Wasilla, AKN1070VKrebs Michael · Elkhorn, WIN1070XMosby Group LLC · Edgerton, MON1070ZSky West Aviation Inc Trustee · Albuquerque, NMN1071HBeck Douglas J · Bloomington, MNN1071JMoore Bradford H · Severna Park, MDN1071VAdvanced Disability Management Inc · Montgomery, TXN1072HBeckman Thomas J · Pocahontas, ARN1072JAcorn Veterinary Services · Woodstock, VA
Back to AD 2011-26-07