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.
N3003DRoach James M · West Bountiful, UTN3003L310-J Enterprises Inc · Parkland, FLN3006DWarmkesserl James R · Felton, CAN3008RPerguson Robert C · Converse, TXN300BRMach Tuck Aero Group LLC · Elkhorn, NEN300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKN300EB4031 Pilots LLC · Crown Point, INN300EJPartwin LLC · Greenwich, CTN300FDGondola Investments LLC · Miami, FLN300MBIglesia De Cristo · Porter Ranch, CAN300PM300pm LLC · Bloomington, INN300SQVortex Aviation LLC · Houston, TXN3010LJones Johnny R · Thermopolis, WYN3011TBranson West Development Inc · Paso Robles, CAN3012TCain James W · Big Rapids, MIN301CPWhy Not Fly Aviation LLC · Gainesville, VAN301DBDon Davis Aviation Inc · Henderson, KYN3020DAllen Gregory L · Lake View, ALFirst renewal noticeN3020RHill James C · Grand Saline, TXN3021TGolden Arrow Transportation · Plainfield, NJN3023LBirge Chad W · Alcoa, TNN3025DBanducci Debra L Trustee · Bakersfield, CAN3026TBox William C · Goldsby, OKN3027RLedford James · Broad Run, VAN3027TPlane Services LLC · Twin Falls, IDN3029TConsolidated Resource Imaging LLC · Grand Rapids, MIN302SKHaynes Daniel R · New Braunfels, TXN3031LCavender Kelly P · Prosper, TXN3031RSearch Gordon · Joliet, ILN3034LTown Thomas L · Chino Valley, AZN3034TVelez Investments LLC · Orlando, FLN3039TDdc Investments LLC · Hot Springs, ARN303DCRegistered aircraftN3040LLuft Inc · North Fort Myers, FLN3040RSturgeon Newton Charles · Midland, TXN3041TSouthern Oregon Skyways Inc · Medford, ORN3042LMsl Holdings · Newbury Park, CAN3042TKls Enterprises Inc · Cave Creek, AZN3043TJwt Aviation LLC · Yancey, TXN3048LLuster Maurice A Jr · Miami Beach, FLN304JWVega Air LLC · Pigeon Forge, TNN304MCValiair Lc Trustee · Casper, WYN3050LMadison Mitchell · Guthrie, OKN3050TLand T Chat · Tulsa, OKN3051TPacific Arts Collection LLC · Oakland, CAN3055TTechnical Education Services · Virginia Beach, VAN3056LFowler Larry K · Harrison, ARN3061DJeppson Edward Mckay Trustee · South Jordan, UTN3063DCase William M · Klamath Falls, ORN3064DLebron R Luke · Gulfport, MS
Back to AD 90-02-13