AD 2013-02-13
Registered aircraft · 24,007
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:2013-02-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:2013-02-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:2013-02-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:2013-02-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.
N101YTJagt Terrence L · Crestline, CAN1020DChimera Air Inc · Maumee, OHN1021XO-D LLC · Kalispell, MTN1022XLeggett Air LLC · Cairo, GAN1023XBickley David R · Pocatello, IDN1024HBellville Timothy L · Toledo, OHN1024QDuroc LLC · Watertown, WIN1024U24u Aviation LLC · Wilmington, DEN1025XCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN1026HNeedham 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, CAN102DHPiper Aircraft Inc · Vero Beach, FLN102EASteves Atv Services Inc · Oceano, CAN102EREmbry Riddle Aeronautical University · Daytona Beach, FLN102FBWelch Richard J · Niceville, FLN102LCMy Technology Services LLC · Miami, FLN102LLExecutive Aviation LLC · Peoria, AZN102PFKaehr 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, FLN1039UIowa Lakes Community College · Estherville, IAN1039XSilvered Wings LLC · Howell, MIN103ATWjm Aviation LLC · Bridgeville, PAN103AVFlying To Infinity And Beyond LLC · Atlanta, GAN103BMSky West Aviation Inc Trustee · Albuquerque, NMN103CCWhatley Wesley E · Plano, TXN103EAJwp 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, INN1040UAmerican Aviation Inc · Brooksville, FLN1040XRacette Robert J Jr · Vienna, WVN1040ZDonnelly Jeff E · Pembroke, MAN1041HCentury Flight Systems Inc · Mineral Wells, TXN1041QSwaz Aviation LLC · Mesa, AZN1041XGyllensten Scott · Guilford, CTN1042UShackleford Developments Of Sc LLC · Mount Pleasant, SC
Back to AD 2013-02-13