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.
N4858PGreat Plains Spraying Inc · Colby, KSN4864YWilliams R E · Fort Walton Beach, FLN4865PThundersky Farms Inc · Helena, MTN4867KMark Thomas Productions LLC · Ketchum, IDN4872KMike Papa LLC · Newton, KSN4875KHolland Karey Lynn · North Plains, ORN4876YCarson Engineering And Manufacturing Inc · Springdale, ARN4878Y182b LLC · La Plata, NMN4880UYanikoski Joseph A · Stoughton, MAN4881U270 W Pearl LLC · Jackson, WYN4885XEggleston Kevin M · Moore, OKN4886USkycase Leasing LLC · Wasilla, AKN4887ZJav Air Services LLC · Anchorage, AKN4888CGoflight Inc · Birmingham, MIN488RHI F Rooks & Associates LLC · Memphis, TNN4891ZRustair Inc · Anchorage, AKN4895YKeating George W · Fayetteville, ARN4896KBraxtal LLC · Kingfisher, OKN4898CPalo Aerocraft Inc · Salem, VAN48ALHutchinson Scott · Missouri City, TXN48CFRaven Girl LLC · Eagle River, AKN48FCSoarmates Inc · Missoula, MTFirst renewal noticeN48VAGeiser Corbin · Little Elm, TXN4905CAnacapa Capital LLC · Fresno, CAN4909YFremont Airways LLC · Riverton, WYN490DBPatkotak Crawford · Barrow, AKN4918UMission Aviation Fellowship · Nampa, IDN4918YGrathwohl Air LLC · Bloomfield Hills, MIN491ACEw Pegasus LLC · Walnut Creek, CAN4922YHowey Aviation LLC · Woodhaven, MIN4923UUnited Indian Missions Inc DBA · Tucson, AZN4925KAlberts Nelson · Weatherford, TXN4930NOneill Aviation LLC · Lake Wales, FLN4939CBard Ralph M · Tullahoma, TNN4939YDavidson Dan F · Ozona, TXN4939ZStaheli Lee E · Kiana, AKN4940KGoves Abram M · Parker, CON4946KOrion Technology Group LLC · San Diego, CAN494PCChristensen Darrel W Jr · Soldotna, AKN4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALN4950UAerotech Mapping Inc · Las Vegas, NVN4950ZRiverside Tractor Inc · Friendswood, TXN4951YH & B Aeronautics LLC · Miamisburg, OHN4955YLancaster Bryant F Jr · Troutman, NCN4957ZGuinasso Kimberly Marsh · Reno, NVN4959CDoll House Properties Inc · Chesapeake, VAN495KKatmai Air LLC · Anchorage, AKN4960KShuck Drilling Co · Edgar, NEN4965ADks Air LLC · Owasso, OKN4967KBrown Lawson M II DBA · San Diego, CA
Back to AD 2002-07-01