AD 2013-02-13
Registered aircraft · 24,007
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:2013-02-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:2013-02-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:2013-02-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:2013-02-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.
N10958Aero Quest LLC · Olive Branch, MSN1095XVillegas Miguel Angel Cuello · Weston, FLN1096TEvans Charles B · Benbrook, TXN1097THorizon Aviation LLC · Brooks, GAN1099JLee'S Sea Air Inc · Kiana, AKN109ATAguillard Robert N · Memphis, TNN109GPCash Management Consulting LLC · Granite Springs, NYN109KBWings Aviation Inc · Valparaiso, INN109LDEast Bay Flight LLC · Alameda, CAN109MBFirefly Aviation LLC · Midland, TXN109RBClark William R · Anchorage, AKN109WESpace Coast Aircraft Co · Merritt Island, FLN10ASCrewson Gary · East Aurora, NYN10BNBlack Thomas D DBA · Clearwater, FLN10DRFlying W LLC · Camden, DEN10GHPeters Darvin Leroy · Meservey, IAN10JKZalan Aviation LLC · Cincinnati, OHN10NZConnor Reginald W · The ValleyNon-citizen corporation, flight hours not reportedN10PBNeves Frank Jr · North Miami Beach, FLN10PJMiller Kenneth R · Russellville, KYN10ZVThat 70s Plane Inc · Athens, GAN1102NWorld Class Athletic Surfaces Inc · Leland, MSN1102XMarak Enterprises LLC · Galena, MON1103XHolmgren Joel A · Chisago City, MNN1104HSkydance Aviation LLC · Chesapeake, VAN1106XVan Vleet Merlin D · Kingman, AZN1107HShurtz William W Jr · Medford, ORN1108HAdk Flying Club Inc · Ballston Spa, NYN1108XThompson Trisha L · Clearwater, KSN1109XBruno Michael J · Pittsburg, CAN110CARegistration Pending · Sturgis, SDRegistration pendingN110GGSkyview Aviation LLC · Tracy, CAN110JA3mw Farms Inc · Hallock, MNN110LMGo Vertical Aviation LLC · Russellville, ALN110MJTuggle Jason C · Liberty Hill, TXN110MSMcaleer Scott · Scranton, IAN110RVMillspaugh John · Weatherford, OKN110TNMaloney Casey · Placerville, CAN110VPFly Aviation Corp · Wilmington, DEN110WRRuffo-Silva LLC · Wilmington, DEN110WTW T Aviation LLC · Wichita, KSN1111MRw Air LLC · Rock Hill, SCN1112XArrow Flyers LLC · Englewood, CON11132Triple One 32 LLC · Sergeant Bluff, IAN1113ULeft Base Aviation LLC · Niagara, WIN1117XHarshman James M · Washington, PAN1118QAscend Aviation LLC · Bountiful, UTN1118XKdr Avgroup LLC · Wilmington, DEN1118ZMoorhouse Mark A · Santa Fe, TNN111AEMatthews Timothy I · Belvidere, NJ
Back to AD 2013-02-13