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.
N802SRBohon Jose S · Corona, CAN802SSBlue Sky Inc · Wilmington, DEFirst renewal noticeN8033HArde Wayne A · Simla, CON8036TPaysse John G · Hanford, CAN8038ZBas Part Sales LLC · Greeley, CON803DBCalifornia Retail Builders Inc · Fresno, CAN803NHCoastal Helicopters Inc · Panama City, FLN803PKCarnine Legal Pllc · Mount Vernon, ILN803SRInternational Air Services Inc Trustee · Carson City, NVN803TSTns Aviation LLC · Coto De Caza, CAN803WFWhiskey Foxtrot LLC · Algonquin, ILN8043BT & A Aviation 2 LLC · Saint Petersburg, FLN8044UCrowe Stephen R Trustee · Lake Ozark, MON8045UCox Clifford J · Armada, MIN804ACOrs22t LLC · Upland, CAN804BABell Aviation LLC · Walnut Creek, CAN804BRLarsen Technology LLC · The Villages, FLN804CLDickerson Richard S · Powhatan, VAN804DBWaterside Aviation LLC · San Jose, CAN804DKParsloe Robert J · Falmouth, MEN804DLFarhad Sigari M D F A C S P C · Marina Del Rey, CAN804HSBb Co LLC · Parker, CON804LP1st Gen Aviation LLC · Richmond, VAN804LXBeepfly Inc · Los Angeles, CAN8051UChandler Christian J · Ashfield, MAN8052MEcho Romeo LLC · Stamford, CTN8055ZAir Hatzis LLC · Baton Rouge, LAN805GHCirrus Design Corp · Duluth, MNN805JCBig Sky Baron Lc · Missoula, MTN805LLAerojet USA LLC · Knox, INN805MXKinsale Associates LLC · Everett, WAN805PMColwell Blue Berry Farm LLC · Ellsworth, MEN805PRValiair Lc Trustee · Casper, WYN805SERc Electronics Inc · Helena, MTN805SGCharlie Golf Aviation LLC · Moorpark, CAN805SRDelta Delta Papa LLC · Fort Lauderdale, FLN805VMazel Wings LLC · Camden, DEN805WTCirrus Design Corp · Duluth, MNN8061VCheairs William T · Covington, TNN8064NSierra Hotel Aviation LLC · Spartanburg, SCN8067UPalmer Eric E · Tucson, AZN8068QCreative Consulting Partners LLC · Fargo, NDN8068USan Diego Flight Corp · San Diego, CAN8069UV115 Aviation LLC · Mount Juliet, TNN806BMAlbatross Aviation LLC · Ponte Vedra Beach, FLN806CDLewis Melvin Lee Jr · Fisk, MON806DKCirrus Design Corp · Duluth, MNN806ECFlynn Development Corp · Clearwater, FLN806GCCoastal Aircraft Services Inc · Gulf Shores, ALN806JDProbe Aviation LLC · Laveen, AZ
Back to AD 2012-10-13