AD 2012-24-09
Registered aircraft · 7,517
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:2012-24-09')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-24-09')
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:2012-24-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-24-09') 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.
N1028GCreed Brian H · Fredericksburg, VAN1029TThomson Heath · Portola Valley, CAN1029XBaden Frederick Richard · Mc Arthur, OHN102EASteves Atv Services Inc · Oceano, CAN102JFAble Enterprise LLC · Tampa, FLN102TMJunior Fernando Sporleder · Sarasota, FLN102WHStuddiford James A · Lithia, FLN102WMStar Air Service LLC · Jacksonville, FLN1031RKeller Paul M · Sanford, NCN1031XJj Byrne International Inc · Steamboat Springs, CON1033TManzo Deborah S · Lake Placid, FLN1036LN1036l Corp · Wilmington, DEN1036XMotley Douglas Trustee · Rehoboth Beach, DEN103ATWjm Aviation LLC · Bridgeville, PAN103BUColorado Aircraft Corp · Watkins, CON103CACivil Air Patrol · Maxwell Afb, ALN103EAJwp Group LLC · Long Island, MEN103ENKjs Development LLC · Temecula, CAN103GLNaylor Aviation LLC · Columbia, MON103HPMcfarland Natalie · Roseburg, ORN103MRDeepvine Partners LLC · Simonton, TXN1041CHelzer Timothy · Tucson, AZN1041GN1041g LLC · Charlotte, NCN1047AHolt Sheet Metal Inc · Durango, CON1047QTaras Brock DBA · Cedaredge, CON1048DDumbravo Dustin C · Yorktown, VAN1049DChihuahua Airport Partners Lp · Plano, TXN1049TRoberts Kevin C · Athens, GAN1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104KGKing & Co LLC · Arroyo Grande, CAN104MQL C Whitford Co Inc · Wellsville, NYN104WPMartyn Christian A · Hallendale, FLN104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIN1050BNine1on Industries LLC · Helena, MTN1050QCouch Kelly P · Elk Grove, CAN1053WPcxii LLC · Greensburg, INN1054XMurphy George E · Robinson, ILN1057QLofty Goals Aviation LLC · Liberty Lake, WAN1057ZAcc Transport LLC · Pomona, CAN105CBFlying Squirrel Aviation LLC · Blacksburg, VAN105CHMach Tuck LLC · Daytona Beach, FLN105HPRyan Transportation Services Ltd · Marysville, OHN105TLSlay Brothers Enterprises LLC · Winter Haven, FLN1063QRussell Construction Co · Douglas, WYN1065SGiacobbe Francesco · Severna Park, MDN1065WCartwright Alexander Brooks · New Paris, INN1068CGunlock Michael G · Boulder, CON10691Reed Kerr Aviation Inc · Wilmington, DEN1069XEntelechy One LLC · Wichita, KSN106ATLichtman Aaron Marcus · Baltimore, MD
Back to AD 2012-24-09