AD 2012-10-13
Registered aircraft · 13,306
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-10-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:2012-10-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:2012-10-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:2012-10-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.
N497MTGomberg Michail V · Geneva, ILN497PDKale Company Aviation LLC · Tremonton, UTN497TZLightspeed Aviation LLC · Lutz, FLN4981CWatson Michael · Dalhart, TXN4981KCuriel Gabriel · Oakley, CAN498BCOutside In Aviation LLC · Fort Madison, IAN498CDCrew Zen Aviation LLC · Fort Smith, ARN498DDCambridge Industries LLC · Rehoboth, MAN498GNChb Aw LLC · Amarillo, TXN498PFProfile Films Inc · Walker, MIN498SRSky West Aviation Inc Trustee · Albuquerque, NMN498TTMiddletown Composites Inc · Berea, KYN4991MOakview Homes LLC · Sullivan, MON4994KMenefee Jerry V · Carson City, NVN499CAHyannis Air Service Inc · Hyannis, MAN499DLCjrr Consulting LLC · Denver, CON499RJNd-Pace Logistics LLC · Sneads Ferry, NCN499VAIdeker Inc · Saint Joseph, MON49AJLvml Real Estate Investments LLC · Rio Grande City, TXN49BSNathaniel Air LLC · Syracuse, INN49CEIttf LLC · Fort Lauderdale, FLN49DACirrus Design Corp · Duluth, MNN49EDOak Country Air LLC · Laguna Beach, CAN49EMCds Air Leasing LLC · Fond Du Lac, WIN49HRBon-36 Ltd · Shavano Park, TXN49LJLacoda LLC · Costa Mesa, CAN49PXN49px Group LLC · West Jordan, UTN49STHedeen Arnold R · Seattle, WAN49WFTech Air Systems LLC · Apollo Beach, FLN4AHHand Kevin D · Anchorage, AKN4ARN4ar LLC · Marienthal, KSN4ETurbo Results LLC · Las Vegas, NVN4GAAircraft Owners And Pilots Association · Frederick, MDN4GHDouble Bridges Aviation LLC · Luxora, ARN4GKDalessandro Janet E · Park Falls, WIN4HAArrington Harold M · Detroit, MIN4HFBat Plane LLC · Memphis, TNN4HYPan American Airways LLC · Durham, NCN4KE4 Kilo Echo Investments LLC · Plantation, FLN4KWFly Aero LLC · Missoula, MTN4LCCorbett Perry Howard III · Ferriday, LAN4LFMacys Flying Service Inc · Tulelake, CAN4LWWilliams Jason Allen · Cypress, TXN4MBBell Michael A · Palo Alto, CAN4MCCoberly Adrian R · Manhattan, KSN4MSCirrus Design Corp · Duluth, MNN4VWPronk Glen R · Crittenden, KYN4WMN4wm LLC · Watkinsville, GAN4XEStavair2 LLC · Gulf Breeze, FLN4YYWilliams Scott Griffin · Salt Lake City, UT
Back to AD 2012-10-13