AD 90-02-13
Registered aircraft · 3,863
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:90-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:90-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:90-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:90-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.
N2688XDw Hamm Consulting LLC · Malibu, CAN2689CColvin Clu DBA · Big Cabin, OKN2689DRegistration Pending · Greenwood, MSRegistration pendingN2689GShandog Air LLC · Ashland, KYN2689TGuillon Inc · Chico, CAN268JBIn Tune Entertainment Inc · Scottsdale, AZN268YMilton Quincy N · Bellevue, WAN2690TN633at LLC · Punta Gorda, FLN2691YLa Paz Holdings LLC · Wetumpka, ALN2692LInnovative Aviators LLC · Norman, OKN2693BDiaz Charles · Ogden, UTN2694HRockingham Carriage Services Inc · Greenland, NHN2695CNovak Peter A · Barrington, ILN2696HSunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeN2696PBlue Wing Aviation LLC · Tulsa, OKN2696UBlack Dragon Consulting LLC · Phoenix, AZN2699DN2699d Corp Trustee · Wilmington, DEN269CGold Beach Lumber Yard Inc · Brookings, ORN269FAir2615 LLC · Wilmington, DEN269PCSch Aviation Inc Trustee · SporleN269WTWillis James A · South Jordan, UTN26GDGragert Richard Trustee · Katy, TXN26HEMccreery Aviation Co Inc · Mcallen, TXN26LFForte Paul · West Bloomfield, MIN26STSky Condor Aviation LLC · Flatwoods, WVN2700YEaton Air LLC · Spearfish, SDN2702LE D Santos & Associates LLC · Wilmington, DEN2702VAtx Aero LLC · Austin, TXN270RCEagle 1-N270rc LLC · San Juan, PRN2712FDodson International Parts Inc · Rantoul, KSN2715TDelaware Aircraft Trust LLC Trustee · New Castle, DEN2718YRichland Aviation Inc · Sidney, MTN2727LAircraft Trustee Services Inc Trustee · Dover, DEN2729LVip Wellness LLC · Victoria, TXN2730MSua LLC · Artesia, NMN2732SBryan Aviation Co LLC · Oelwein, IAN2732TJellor Realty Inc · Los Angeles, CAN2734BStella Air Inc · Wyoming, PAN2734GSplit Rock Aerospace LLC · Southport, CTN2735JAlpha 414a LLC · New Smyrna Beach, FLN2738BSonrise Aviation LLC · Portland, INN2740TKraybill Paul D · Portola Valley, CAN2742HWilbert John W III · Plaquemine, LAN2744PTouchdown LLC · Pls Vrds Est, CAN2744XAccelerated Slipstream LLC · Livermore, CAN2744YDe Vuyst Richard C · Pampa, TXN27457Felix Margarita G · Nogales, AZN2745FAlexander Production Co · San Antonio, TXN2745GKj3 Air LLC · Mitchell, SDN274DCMaggie 288 LLC · Quincy, WA
Back to AD 90-02-13