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.
N311JHHuaco Aviation LLC · Waco, TXN311KMDream Flight Florida LLC · Wellington, FLN311RWWashburn Harrill Gene Jr · Rutherfordton, NCN311SKDoyle Thomas Michael · New City, NYN3122LE C G Aviation Inc · Orange, CAN3125LOxley Lake Solutions LLC · Lawton, MIN3127LContainer Stop Inc · Paso Robles, CAN3127TSouth Valley Internet Inc · San Martin, CAN312CSFlybuys3 LLC · Lewes, DEN312MXRapid Imaging Solutions LLC · American Fork, UTN3131KAmazon Aero Corp · Wilmington, DEN3134LTrax Eric E · Vero Beach, FLN3135LTempelhof Aviation · Las Vegas, NVN313JHJam Three LLC · St George, UTN313RWSarp Rentals LLC · Loudon, TNN314DBrantley Hugh Lawton · Hazlehurst, GAN314GRVice One LLC · Las Vegas, NVN314MGSummit Aviation LLC · Las Vegas, NVN314UPro Aire Cargo & Consulting Inc · Oshkosh, WIN3150LS & S Aircraft Inc · El Dorado, ARN3153LMiller James R · Parowan, UTN3154LOnisko Aidan C · Williams, CAN315MDuckwing LLC · Reno, NVN3162LG&M Aircraft · Wheat Ridge, CON3165LToll Harry V · Tucson, AZN3169LPhillips James A · Burlington, WIFirst renewal noticeN316RALeading Edge Flight Services Inc · Hampshire, ILN316WCEagle Aeronautics LLC · Chicago, ILN3171Derr Matthew R · Frackville, PAN3179LPeregrine Aviation LLC · Oro Valley, AZN317LAviation Adventures And Publications Inc · Wilmington, DEN317MZValiair Lc Trustee · Casper, WYN3183L4 All In Inc · North Fort Myers, FLN3184LKimbrell Heath · Quinlan, TXN318PPK&A Consulting Of Montana Inc · Billings, MTN318TWFlg Air Transport LLC · Miramar, FLN318UTraffic Law LLC · Tampa, FLN3192LPolk Kenneth W · Greenville, TXN3195MAspire Management Inc · New Castle, DEN31AWRestoration Dental · Chesterfield, MON31CLg & Gs Holdings LLC · Middletown, DEN31CULovaas Jean H Trustee · Crescent City, CAN31GKMartin Richard B · Corona Del Mar, CAN31KCWashington State Community College · Spokane, WAN31KGMidwest Corporate Air Inc · Bellefontaine, OHN31KSPaxton Jacob · Killeen, TXN31KTSmith Kenneth L · Pomona, CAN31MMPence Air LLC · Edinburg, VAN31PGPlacette Jim · Houston, TXN31RTPapuchin LLC · Highwood, IL
Back to AD 90-02-13