AD 2002-07-01
Registered aircraft · 3,466
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-07-01')
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-07-01')
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-07-01') 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-07-01') 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.
N8131GTalley Edward P · San Jose, CAN8137GTwo Ten K LLC · Upper Sandusky, OHN8137LShreve Jerry · Warrensburg, MON8138GRab Com Limited · Hayward, CAN8139LWashburn Kyle A · Yukon, OKN813DMAp-1 LLC · Newman Lake, WAN813SWWolff Scott · Missoula, MTN8141GBitter Creek Investments LLC · Cascade, IDN8143GRegistration Pending · Sparks, NVRegistration pendingN8146QOak Gulch LLC · Killdeer, NDN8159MHowell Andrew · Pinedale, WYN81631Kelly Jon B · Anchorage, AKN8167QCedar Pine Construction Inc · Sturgis, SDN8183MHaman Peter A · Douglas, WYN818PCWindigo Transportation Inc · Waterloo, IAN8198GSky Wagon LLC · Phoenix, AZN81DTKbk Aviation LLC · Youngsville, LAN81KCCraigo Keith A · Addison, TXN81MTBennett Thomas Richard · Brooklyn Park, MNN81SCGl Aircraft Enterprise LLC · Wilmington, DEN81TPPowers Charles M · Greenwood, MSN81ZHCarlsbad Raceway Corp · Hemet, CAN8203MBottle Meister Inc · San Luis Obispo, CAN820AHBuffaloe Thomas N · Mancos, CON8210MPeavy Magnus Delacy IV · Crawfordville, FLN8219MFair Winds Group LLC · Portage, MIN8222MFrank Sherril P · Grapevine, TXN8225MCarlson Farms Inc · Plentywood, MTN8225QCartoflight Inc · Willoughby, OHN8229MOlsen Frances K · Bostwick, GAN8233MSixty Nine Kilo LLC · Oakland, CAN8237MMiddle Tennessee State University · Murfreesboro, TNN8241MVenema-Ashmore Karin · East Dixfield, MEN8249MRancho Bonito LLC · Oxnard, CAN824MAE D Santos & Associates LLC Trustee · Wilmington, DEN8252MApplied Olap Inc · Huntsville, ALN8253MHudak Organization LLC · Cedar Grove, NJN8253QTogo Aviation Services LLC · Palmer, AKN8254QTogo Aviation Services LLC · Palmer, AKN8255QKavik Aviation Services LLC · Palmer, AKN8256QRegistered aircraftN8260MCloud Dancer LLC · El Paso, TXN8261MZaller Anthony J · Phoenix, AZN8262MThrasher Dennis L · Tucson, AZN8263GFitzpatrick Dennis B · Mccall, IDN8264QMoody Bible Institute Of Chicago · Spokane Valley, WAN8266MCenturion Aviation LLC · Groveland, FLN82687Boniek Martin J · Mccarthy, AKN8271MBoyd David R · San Jose, CAN8273QHelmericks Isaac J · Palmer, AK
Back to AD 2002-07-01