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.
N4810YInternational Air Services Inc Trustee · Carson City, NVN4813P4813p LLC · Newport, MEN4816JMorten Derek J · Northwood, NDN481FDCirrus Design Corp · Duluth, MNN481GJGdjones Aviation LLC · Blue Mounds, WIN481MWN481mw LLC · Reno, NVN481PMoody Bible Institute Of Chicago · Spokane Valley, WAN4827PCarlson Chris · Redwood City, CAN4827UHagen Rainer · Irving, TXN4828KFlywerx LLC · Anchor Point, AKN4829KCanal Flight LLC · Portland, ORN482CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN482DMRmb Flight LLC · Melbourne Beach, FLN482KBBethune Kenneth · Huntsville, ALN482WTExecutive Aero Flight Club LLC · Cedar Rapids, IAN4830KRamaker LLC · Choteau, MTN4833AEnoch Mark C · Rowlett, TXN4834KBurke Kenneth V · Payson, AZN4834WParker Larry C · Roswell, NMN4837ALongleaf Wing Ventures LLC · Birmingham, ALN4838KCommercial Tenant Improvement Corp · Alta Loma, CAN483ADCirrus Design Corp · Duluth, MNN483DMN483dm LLC · Hummelstown, PAN483JFKg Aviation LLC · Huntington, WVN483PN483p LLC · Elizabethtown, PAN4842KKinetic Group LLC · Eagle, IDN4844KMccoy Robert G Jr · Marshville, NCN4845CBloss Albert P · Seattle, WAN484KCN484kc LLC · Salem, ORN484KWNunez-Fontes Fernando · Rio Rico, AZN484LACirrus Design Corp · Duluth, MNN484SWElsass Aviation LLC · Fayetteville, ARN484TManhattan Medical Consultants LLC · Mckinney, TXN4853CIdaho Flying Service LLC · Kamiah, IDN4857CGate Holdings LLC · Ketchum, IDN4858MAir Services Inc · Red Lodge, MTN4858PGreat Plains Spraying Inc · Colby, KSN485DVCluny Aviation LLC · Pinehurst, NCN485DWDashj Corp · Fort Salonga, NYN485EMSpirit Of Paris LLC · Saratoga, CAN485KBEmpennage Holdings LLC · Keene, NHN485VBSiegel Stephan · Boynton Beach, FLN485VTRam 485vt LLC · Yeadon, PAN4865PThundersky Farms Inc · Helena, MTN4867KMark Thomas Productions LLC · Ketchum, IDN486DCStephens Dana M · Coxs Creek, KYN486JP486jp LLC · Buhler, KSN486MHMh Group LLC · Duncan, OKN486WBWorry Bird Aviation LLC · Fall River, MAN486WCQuantum Ventorum LLC · Waitsfield, VT
Back to AD 2012-10-13