AD 2012-10-52
Registered aircraft · 2,750
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-52')
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-52')
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-52') 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-52') 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.
N2378XState Of Utah · Salt Lake City, UTN2378YLindsey Aviation Services · Haslet, TXN2379FWebster Douglas Clark · Las Vegas, NVN2381YInvictus Investments LLC · Urbandale, IAN2383LNebraska State Patrol · Lincoln, NEN2384SChervenak A Douglas · Smyrna, DEN2389GMacon Septic Systems Co Inc · Macon, MSN2389LCjw Holdings LLC · Stamping Ground, KYN238TLLow Sean · Midland, TXN2391EInnova Energy LLC · Wilmington, DEN23HBHotel Bravo Aviation LLC · Houston, TXFirst renewal noticeN23VMOrange Skies LLC · Great Falls, VAN2400TAircraft Guaranty Corporation Trustee · Oklahoma City, OKN240CPCivil Air Patrol · Maxwell Afb, ALN240PSN240ps LLC · Mesa, AZN240TBN54za LLC · Houston, TXN241MPGv Air Inc · Medford, ORN2423SAircraft Sales LLC · Caledonia, MIN2425SPark Sung S · Marana, AZN24287J B C Development LLC · Evans, GAN24293Digitalev LLC · Westminster, CON2429RJones Adam · Fairbanks, AKN242TC182 Flight Corp · Bronx, NYN242TJMagee Timothy I · Gulfport, MSN242VPirshafiey Nasser Charles · Trabuco Canyon, CAN242WBUnited States Department Of Interior · Boise, IDN24301Pacific Coast Cycle Corp · Kings Beach, CAN2430QBeavercat Air LLC · Myrtle Point, ORN2437UPlanetosea LLC · Doylestown, PAN243RZBest Aircraft Deals LLC · Salt Lake City, UTN2440PN2440p LLC · Seattle, WAN2440VVehrs Roger K · Roseburg, ORN2441GTognoli Stefano F · Union, ORN2441SSzpara John V Trustee · Chesnee, SCN2441YTag Aviation LLC · Santa Teresa, NMN2446ESugarloaf Air LLC · Wilmington, DEN244MEEagle Forestry Services Inc · Monticello, ARN24507Pena Jairo · Catharpin, VAN24518Fly Arkansas LLC · Harrison, ARN2451A722jc LLC · Tyler, TXN2451YSalmon Michael J Trustee · Albuquerque, NMN2453SFilipponi-Thompson Drilling Inc · Atascadero, CAN2455XRucker Aviation Logistics Inc · Shingle Springs, CAN24569Pt Logistics LLC · Rye, NHN2456HPappusgrass Aviation LLC · San Antonio, TXN2456LNew West Ventures II Inc · Rancho Santa Fe, CAN245BTMichael Knapp · Galveston, TXN24607Fey Properties LLC · Pleasanton, CAN2461FDietz Thomas · Mill Valley, CAN2464CCantera La Rita Inc · San Juan, PR
Back to AD 2012-10-52