AD 2002-19-10
Registered aircraft · 1,092
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:2002-19-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-10')
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:2002-19-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-19-10') 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.
N5059JTanner Flying Service Inc · Cortez, CON5059VKross Lessyn Aerial Inc · Hereford, TXN505FAAir Cover Crop Solutions LLC · Frankford, MON50669Tri Rotor Spray And Chemical · Ulysses, KSN5066CFarm Ag Enterprises LLC · Buckeye, AZN506FAPontiac Flying LLC · Pontiac, ILN5070HKubecka Operating Company Inc · Seminole, TXN50738Farm Air Inc · Astoria, ILN50761Arthur Aviation LLC · Arthur, NDN507FAGarrett Flying Service Inc · Danbury, TXN5083MLakeview Aviation Inc · Sanborn, NDN5085QScl Aviators · Wilmington, DEN5086HCavanaugh Flying Service Inc · Minden, NEN508DGOld River Flying Service LLC · Wabash, ARN5091HLake Air Service LLC · Jennings, LAN50927Prairie Ag Service LLC · Des Arc, ARN5094HWoodley Aerial Leasing LLC · Walnut, ILN5096YHangar 8 Spray Service LLC · Clark, SDN509ZPNeal Aircraft Inc · Slaton, TXN5110SChoctaw Flying Service Inc · Inverness, MSN5110ZPonderosa Airtankers LLC · Safford, AZN5111ABasin Aviation Inc · Rio Oso, CAN5120EC & L Holzwarth Inc · Virden, ILN5123UR & D Leasing Inc · Lemoore, CAN5124PIndependent Dusting Service Inc · El Campo, TXN5128NBasin Aviation Inc · Rio Oso, CAN512LAWestern Pilot Service Inc · League City, TXN5144DKeo Ag Service Inc · Keo, ARN514FAAir Tractor Inc · Olney, TXN5166JFitchs Flying Service LLC · Pearsall, TXN5175BMiller Aviation Inc · Norton, KSN5175VHound Dog Enterprises LLC · Terre Haute, INN51771Air Kraft Spraying Inc · Timber Lake, SDN5182BFirst State Ag Air Inc · Viola, DEN5185ERoberson James L · New Braunfels, TXN5185KBank Of Utah Trustee · Salt Lake City, UTN5189RWoodley Aerial Leasing LLC · Walnut, ILN5191BBank Of Utah Trustee · Salt Lake City, UTN5192FJohnson Airspray Inc · Argyle, MNN5192TAero Applications Inc · Burley, IDN519CKAgwerx Aviation Inc · Yuma, CON5202XBoair Inc · Merigold, MSN521BFBs Flying Service LLC · Middletown, DEN522BFBs Flying Service LLC · Middletown, DEN522LAWallin Michael · Walnut Ridge, ARN522LLRegenald Michaud Aviation LLC · Willows, CAN523BFPadgett Ag Rotors LLC · Missoula, MTN523RBAnderson Interests LLC · East Bernard, TXN526FAAir Tractor Inc · Olney, TXN5272TIndependent Dusting Service Inc · El Campo, TX
Back to AD 2002-19-10