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.
N282TMWhite C Derrick · Southlake, TXN2834YAvance Aircraft LLC · Wilmington, DEN283DFrohbieter Alan · Superior, CON283DDMosier Don · Stanford, KYN283RDBengtson Douglas Richard · Woodinville, WAN283SRArtemis Aviation LLC · Mondovi, WIN283TBNance Joseph W · Fort Collins, CON283TMSpady Jeffrey · Springfield, ORN283WTBlue Nexus LLC · Lewes, DEN2844DMichigan Aeronautics Commission · Lansing, MIN28487Jcb Enterprise LLC · Wilmington, DEN284CDOld Hickory Flyers · Franklin, TNN284KBRoper Lawrence F Jr · Georgetown, SCN284LMB-Airborne LLC · Woodbine, MDN284SVQuality Feed Grains · Harrison, ARN2856QFoster Aaron J · Missoula, MTN285AHOsi Aviation LLC · Sarasota, FLN285HPGaines Robert M · Nashville, TNN285KAGtb Aviation LLC · Seattle, WAN285SJSoul Plane LLC · Greenwood Village, CON285TCSickinger Alan W · New Philadelphia, OHN285WT285wt LLC · Wilmington, DEN2865BBui Gregory M · Tigard, ORN286AKDog Island Air Inc · Wilmington, DEN286BBBell Family Cirrus LLC · Louisville, KYN286CMB&K Aircraft Leasing LLC · West Plains, MON286DAAmitin Daniel · Los Angeles, CAN286FDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN286LDSpectre Aviation Group LLC · Johnson City, TNN286MWGeneral Purpose Vehicle LLC · San Francisco, CAN286TCJb Aviation LLC · Waxahachie, TXN287AACirrus Design Corp · Duluth, MNN287CPAlves Philip · Sandy, UTN287DSCustis Cirrus Aviation LLC · Birmingham, ALN287JBQ&A Holdings LLC · Elkridge, MDN287KMO'Connor Thomas F · Plano, TXN287LMDjc Bonanza LLC · Stuart, FLN287THTh Aviation LLC · Savannah, GAN288MTgc Aviation LLC · Watkinsville, GAN288MJRocky Ford Leasing LLC · Tallahassee, FLN288PWSummit Peak Ventures LLC · Danville, CAN288TATurbine Time LLC · Mercer Island, WAN288WTBas Part Sales LLC · Greeley, CON28913Bellas Business LLC · Kalispell, MTN289AA289 Aero Holdings LLC · Renton, WAN289AMBoston Family Holdings LLC · Miramar Beach, FLN289EMorrison Matthew J · Waco, TXN289KCBonner Aviation LLC · Billings, MTN289SBHemcka Aviation LLC · Bradenton, FLN28APAircraft Trust & Financing Corp Trustee · Wilmington, DE
Back to AD 2012-10-13