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.
N8245JSln Aviation LLC · Salina, KSN8248BSmith Kirk A · Searcy, ARN8248KPlane Haven LLC · Kalispell, MTN8249MRancho Bonito LLC · Oxnard, CAN824ARLowman LLC · Fairfax, VAN824BCAonvo Investment LLC · North Miami, FLN824DGSadie Aviation LLC · Mars, PAN824DJBcd Aviation LLC · Waleska, GAN824EBRiverstone Aviation LLC · Saint Paul, MNN824EJTwo Bravo LLC · Fargo, NDN824ETSwift Charles Wesley Jr · West Plains, MON824HJC & W Aviation LLC · Birmingham, ALN824KBHope Aviation LLC · Lakota, NDN824MAE D Santos & Associates LLC Trustee · Wilmington, DEN824MKGoldenair LLC · Wellesley, MAN824MRTspy Services Inc · Wilmington, DEN824PCapital Premium Finance · Tallahassee, FLN824PFWashington Square Cirrus LLC · Sagaponack, NYN824RBShark Water Systems LLC · Hobbs, NMN824RLRhh Consulting LLC · Nashville, TNN824TPOur Gang Air LLC · Malvern, PAN824WBGlc Ventures Capital Holdings LLC · Ponder, TXN824WFAlmon Aviation LLC · Snohomish, WAN824WLValiair Limited Co Trustee · Casper, WYN824XZCny Flying Cardiac Services LLC · Fayetteville, NYN82500Snider Douglas H · Seguin, TXN8256HGj Flight Group LLC · Newark, DEN8257HS And G Ventures LLC · Wilmington, DEN8259AParisien Robert · Bow, NHN825CCRegistered aircraftN825CD825cd LLC · Camarillo, CAN825DLSunair LLC · Aspen, CON825ECPeterson Air LLC · Chisago City, MNN825FWRegistered aircraftN825HADiamond Aviations LLC · De Witt, IAN825JCCirrus 23 LLC · Tulsa, OKN825JHWagner Ronald J Trustee · Brentwood, CAN825TGDodenhoff Robert M · Middletown, CTN825TRGap Aviation LLC · Carencro, LAN825UMCirrus Design Corp · Duluth, MNN8261K8th Street Aviation LLC · Urbandale, IAN8261VTds Airpro LLC · Shreveport, LAN8263GFitzpatrick Dennis B · Mccall, IDN8263VPrecision Service Mtr Inc · Addison, ILN8264QMoody Bible Institute Of Chicago · Spokane Valley, WAN8265XOzark Management Inc · Columbia, MON826BBMamia Motorsport LLC · Houston, TXN826BJRbh Aviation LLC · Fishers, INN826DXWave At Mountains LLC · Long Beach, CAN826DZDeka LLC · Mechanicsville, VA
Back to AD 2012-10-13