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.
N3206YN3206y Aviation LLC · Bloomfield Hills, MIN3209DCirrus 1jr LLC · Webster, NYN3209JDennis John W · Mooresville, NCN320BVLaird Brian N · Monument, CON320CAArmstrong Resource Management Corp · Knoxville, TNN320CDSimpulse Inc · Oregonia, OHN320DFDfig Holdings LLC · Kalispell, MTN320DGSrs 320 LLC · Houston, TXN320DRMontgomery Machine LLC · Guilford, CTN320EBKenmore Crew Leasing Inc · Bellingham, WAN320ETVdv Properties LLC · Bend, ORN320MSConsulat Inc · Cheyenne, WYN320PCAom Aircraft LLC · Wilmington, DEN320RLLast Flight Out LLC · Brentwood, TNN320RMRd Harrison Inc · Lexington, NCN320RRHighway Aero LLC · Bristow, VAN320SKDevries James E · Bejou, MNN320SWEast West Investment Advisors LLC · Sandy Point, VAN320TJBlaylock Arthur S III · Pace, FLN3210PKilcullen Brian DBA · Fort Lauderdale, FLN3212DHalo Aviation Corp · Wilmington, DEN3212GGibby Aviation Inc · Wilmington, DEN3213DMountaingales LLC · Phoenix, AZN3214ZYounger Aviation LLC · Poteau, OKN3215DSchlund James F · Chico, CAN3215UAileron T LLC · Orlando, FLN3216MN3216m Inc Trustee · Carson City, NVN3216ZMy Fly LLC · Wilmington, DEN3217EDavis Darren · Flint, TXN3217MN3217m LLC · Polson, MTN3218XMjm Flying LLC · Traverse City, MIN321AZBuilders Aviation LLC · Algona, IAN321BGItinerant Orl LLC · Columbia, SCN321BLWalls Bruce · Middletown, OHN321CEGreen Eggs And Ham Aero LLC · Helena, MTN321CFTekswork Aviation LLC · London, KYN321DDGreene Jonathan U · Pompano Beach, FLN321EKCielo Holdings Group LLC · Ormond Beach, FLN321ETVlt Aviation LLC · Tampa, FLN321FLSkywalker Aviation LLC · Saint Paul, MNN321GKBrown Water Associates LLC · Monticello, FLN321GSXenu Aircraft LLC · Hatfield, PAN321HDodson International Parts Inc · Rantoul, KSN321HBYosemite Axe Throwing · North Fork, CAN321HTPartnairs LLC · Lake Charles, LAN321JAJa Consulting LLC · Delray Beach, FLN321JHSkidmore Gary DBA · Terreton, IDN321JJJayjet Private Aircraft Charter LLC · Swanton, OHN321JMEo Liquidation Inc · Whitehouse Station, NJN321JRAcademy Aviation Services LLC · Cedar Park, TX
Back to AD 2012-10-13