AD 2002-25-07
Registered aircraft · 542
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-25-07')
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-25-07')
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-25-07') 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-25-07') 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.
N206GSBank Of Utah Trustee · Salt Lake City, UTN206LJJohnson Flying Service LLC · Exira, IAN206LRHawk Flight · Craig, CON206LWStanislaus County Sheriffs Department · Modesto, CAN206MPWhirl'D Helicopters Inc · Sevierville, TNN206RFRotors Unlimited LLC · Middletown, DEN206SGClassic Medical Inc · Salt Lake City, UTN206SLAv8-Orr Helicopter Services Inc · Hamilton, MTN206UHPadgett Farms And Forestry LLC · Milan, GAN206UKCrop Flight LLC · Divernon, ILN206VCVentura County Sheriff'S Dept · Camarillo, CAN206WLSummit Helicopters Inc · Salem, VAN206WXXtreme Aviation LLC · Falkville, ALN2070UAero-Tech Helicopters LLC · Kingstree, SCN2072MOrlando Aircraft Sales LLC · Orlando, FLN207CPPremier Rotors LLC · Saint Martinville, LAN207EHTexcrete Inc · Kurten, TXN207MHMeridian Helicopters LLC · Broussard, LAN207RHMorris Equipment LLC · Yuma, AZN209CPSouthern Helicopters Inc · Sunshine, LAN20TVHelicopters Inc · Linden, NJN20ZPatriot Aviation Inc · Greenville, DEN210MHCirrus Air Express LLC · Lewes, DEN210TVNexstar Media Inc · Irving, TXFirst renewal noticeN2122T22t Aero LLC · Hermosa Beach, CAN2150MT&M Aviation Inc · Abbeville, LAN216LSPremier Rotors LLC · St Martinville, LAN216MHMeridian Helicopters LLC · Broussard, LAN216TVDel Rio Aviation Inc · Paso Robles, CAN217MHMeridian Helicopters LLC · Broussard, LAN219RHRc Aviation Inc · Lumpkin, GAN220MHPremier Rotors LLC · Saint Martinville, LAN225AEAir Evac Ems Inc · O Fallon, MON225GHRayburn Asset Holdings LLC · Mansfield, TXN225RHValiair Limited Co Trustee · Casper, WYN226SHScotts Helicopter Services Inc · Le Sueur, MNN227MHDelta Southern Resource Leasing LLC · Baton Rouge, LAN228AEAvid Aviation Group Inc · Jupiter, FLN228PBCrop Flight LLC · Divernon, ILN229AEAir Evac Ems Inc · O Fallon, MON22UKOas2 LLC · Orlando, FLN22ZAPmp55 LLC · Slingerlands, NYFirst renewal noticeN230MHLivingston Parish Sheriff'S Office · Livingston, LAN231BBCoastal Air Service Inc · Panama City, FLN232MHLipsey Helicopter Rental Co LLC · Chattanooga, TNN233AEAir Evac Ems Inc · O Fallon, MON233BBTop Gun Precision Ag LLC · Skidmore, TXN233MHMeridian Helicopters LLC · Broussard, LAN238SRApple Realty Group Inc · Richmond, VAN239AEAir Evac Ems Inc · O Fallon, MO
Back to AD 2002-25-07