AD 2012-10-52
Registered aircraft · 2,750
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-52')
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-52')
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-52') 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-52') 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.
N193TTBgiii Air LLC · Tampa, FLN194DDLcb Leasing · Bristow, VAN194TWGreenway William Kendal · Greensboro, GAN1953UAnstrand Charles Jason · Boise, IDN1961UMccarthy Trevor William · Addison, TXN1962GGr Aviation LLC · Key Biscayne, FLN1962KMria LLC · Albuquerque, NMN1968RCloud Transport Operations LLC · Albuquerque, NMN196CPCivil Air Patrol · Maxwell Afb, ALN196TTNbr Aviation · Bristow, VAN196TWTango Lima Flying LLC · Lawrence, KSN1973USilver Fox Aviation LLC · Bay City, MIN197WSObr Leasing · Bristow, VAN198ERCloud Dancer LLC · Santa Maria, CAN198RNKqm Aviation · Bristow, VAN199PWJ & C Express Inc · Carbondale, ILN199TEPxw Services · Greenville, DEN19FBWojnicki Chester · Mt Prospect, ILN19LBSanders Brian L · Tehachapi, CAN19LMM & M Skyshare LLC · Winter Park, FLN19TLHall Kurt D · Fort Lauderdale, FLN1KPSherman Loren R Jr · Granbury, TXN1LQStrydom Cornelis F · Liberal, KSN1SLHotel Kilo Aviation LLC · Anchorage, AKN200QRPdq Flight Inc · Garden City, NYN200RCRc Aviation LLC · Omaha, NEN200UAUrrea Hugo Edmundo Rincon · Houston, TXN200WRVaughan Jason B · Sublette, KSN2011SHeath Stephen · Alpine, TNN2012S9791m LLC · Tacoma, WAN20135Africair Inc · Miami, FLN2019SMoore Bobby E · Perry, OKN2028SScherler Burl M · Sheridan Lake, CON202MCBeemer Companies · Fairmont, MNN2037SRubyco Inc Trustee · Wilmington, DEN2038SHatch Family Limited Partnership · Winslow, AZN2042SGausman Grace K · Lompoc, CAN2043SAppel Daniel E · Redfield, SDN2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeN204JHLivin The Dream Too LLC · St Paul, MNN204RSKenai Peninsula Air Transportation & Lodging LLC · Lake Havasu, AZN204TSAs The Crow Flies Aerial Services LLC · Irving, TXN2050SDavis Bryan C · Winfield, KSN2055QJones Jeff A · Lewiston, IDN2056SAcevedo Adriel · San Antonio, TXN2059U5c Valley Aviation LLC · Sun Valley, IDN2061Ramos Sammy · San Juan, PRN20617Mtnairpower LLC · Santa Barbara, CAN2064FMicrowave Rental LLC · Beaufort, SCN2064PPrivitt Bret · Hudson Oaks, TX
Back to AD 2012-10-52