AD 2002-20-05
Registered aircraft · 2,705
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-20-05')
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-20-05')
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-20-05') 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-20-05') 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.
N206NEJayg Exotics · Lakewood, NJN206NUNorth Wind Aviation LLC · Chelan, WAN206NYHornet International LLC · Picayune, MSN206PC10wg LLC · Newman Lake, WAN206PHTaz Investments LLC · New Iberia, LAN206PLAerial Control Inc · Brentwood, CAN206RFRotors Unlimited LLC · Middletown, DEN206RHPure Sports Inc · Tavares, FLN206RMPadgett Farms And Forestry LLC · Milan, GAN206RVTaylor Made Aircraft Co LLC · Broomfield, CON206RYEast Tennessee Helicopters Inc · Butler, TNN206SAGarlick Joyce M · Hamilton, MTN206SFAlpha Echo Leasing LLC · Sedona, AZN206SGClassic Medical Inc · Salt Lake City, UTN206SHMc Helicopter LLC · Summerfield, FLN206SKLatschar Barry D · Oklahoma City, OKN206SLAv8-Orr Helicopter Services Inc · Hamilton, MTN206SWCounty Of Ocean · Barnegat, NJN206TATomlinson Aviation Inc · Ormond Beach, FLN206TDHomestead Helicopters Inc · Missoula, MTN206TGGallien Anthony · Livermore, CAN206THRanger Aviation Leasing LLC · Wilmington, DEN206TLTurbines Ltd · West Point, NEN206TRZma LLC · North Little Rock, ARN206TWAltitude Solutions LLC · Kalispell, MTN206UHPadgett Farms And Forestry LLC · Milan, GAN206UKCrop Flight LLC · Divernon, ILN206UWWaverly 206 LLC · Oklahoma City, OKN206VCVentura County Sheriff'S Dept · Camarillo, CAN206VLMalahaide Investments Inc · Wilmington, DEN206WAChem Air LLC · Shreveport, LAN206WCRuckle Kelby J · Whittemore, MIN206WFBettencourt Flying Service Inc · Atwater, CAN206WGWorld Golf LLC · Charles City, VAN206WLSummit Helicopters Inc · Salem, VAN206WXXtreme Aviation LLC · Falkville, ALN206XZSunwest Construction Enterprises Inc · Tarpon Springs, FLN206YARantzair Inc · East Wenatchee, WAN206YTRocky Mountain Grading LLC · Alamo, NVN206YYMshr Helicopter Service LLC · Chehalis, WAN206ZZAv Enterprises Inc · Bozeman, MTN2070KRudy Schmitt · Brookshire, TXN2070UAero-Tech Helicopters LLC · Kingstree, SCN2072MOrlando Aircraft Sales LLC · Orlando, FLN207CPPremier Rotors LLC · Saint Martinville, LAN207DHAirone Helicopters LLC · Slaughter, LAN207EHTexcrete Inc · Kurten, TXN207MHMeridian Helicopters LLC · Broussard, LAN207RHMorris Equipment LLC · Yuma, AZN207SJSan Juan Aviation LLC · Wilmington, DE
Back to AD 2002-20-05