AD 95-26-13
Registered aircraft · 21,467
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:95-26-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
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:95-26-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13') 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.
N1026HNeedham John A · Southington, CTN1026XLopp Russell · Yukon, OKN1027BMarshall Loraine · Cincinnati, OHN1027FFilarski Darryl M · Grosse Ile, MIN1029HRegistration Pending · Bulverde, TXRegistration pendingN1029XBaden Frederick Richard · Mc Arthur, OHN102DEUniversal Aviators Academy Inc · El Monte, CAN102EASteves Atv Services Inc · Oceano, CAN102EREmbry Riddle Aeronautical University · Daytona Beach, FLN102FBWelch Richard J · Niceville, FLN102LCMy Technology Services LLC · Miami, FLN102PFKaehr Lyle · Decatur, INN1030NDcaw Aviation LLC · Advance, NCN1033XHorizon Enterprises LLC · Kalispel, MTN1034XBlasa Randy · Bowling Green, FLN1035XSocal Blue Side Up LLC · Anaheim, CAN1036QKelley Michael · Bellingham, MAN1036XMotley Douglas Trustee · Rehoboth Beach, DEN1038FPetrick Dan A · Punta Gorda, FLN1039XSilvered Wings LLC · Howell, MIN103ATWjm Aviation LLC · Bridgeville, PAN103AVFlying To Infinity And Beyond LLC · Atlanta, GAN103EAJwp Group LLC · Long Island, MEN103JKWise Charlie S · Norfolk, VAN103KCLang Elmer N · Hemphill, TXN103RRLancaster Flyers LLC · Fenwick Island, DEN103SAHolman Steven R · Vero Beach, FLN103TTAero Dynamics Flying Club Inc · Mulino, ORN1040HKing Jay M · Kokomo, INN1040XRacette Robert J Jr · Vienna, WVN1041HCentury Flight Systems Inc · Mineral Wells, TXN1041QSwaz Aviation LLC · Mesa, AZN1041XGyllensten Scott · Guilford, CTN1042XN1042x LLC · Papillion, NEN1043QRegistered aircraftN1043XAustin Security Corp · Battleboro, NCN1045Paragon Airplane Leasing Co · Fort Myers, FLN1046XFarnham Aviation Services LLC · Ames, IAN1047HMagel James · Fox River Grove, ILN1047MChristiansen Aviation LLC · Wilmington, DEN10480Piper 66 LLC · Kirksville, MON1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104AAMeridian Aircraft LLC · Wilmington, DEN104DHPiper Aircraft Inc · Vero Beach, FLN104EREmbry Riddle Aeronautical University · Daytona Beach, FLN104FGWilson Conrad · Bowdon Junction, GAN104GKIndigo Bunting Aviation LLC · Morristown, NJN104TBMclear Robert C · Rock Hill, SCN104VADulles Aviation Inc · Bristow, VAN1051XNormand Glendon · Marksville, LA
Back to AD 95-26-13