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.
N108SCCounty Of Sonoma · Santa Rosa, CAN108WWeyerhaeuser Nr Co · Eugene, ORN109AGO'Brien Helicopters Inc · Lehigh Acres, FLN109AHEurotec Vertical Flight Solutions LLC · Eudora, KSN109ALEurotec Vertical Flight Solutions LLC · Eudora, KSN109BMRegistration Pending · North Salt Lake, UTRegistration pendingN109BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN109CGEurotec Vertical Flight Solutions LLC · Eudora, KSN109CYO'Brien Derrick P · Middletown, DEN109DDLitton Global LLC · Wilmington, DEN109DXSunwest Construction Enterprises Inc · Tarpon Springs, FLN109FBCity Of Phoenix · Phoenix, AZN109GLA Air Club LLC · Tampa, FLN109HNPrestige Air LLC · Aliso Viejo, CAN109LRCenterline Holdings Inc · Camden, DEN109MHGateway Air Center Inc · Merced, CAN109MMAirborne Leasing Inc · Sylmar, CAN109NLIntegrity Aircraft Title Holdings LLC · Portland, ORN109PPhoenix Helicopters LLC · Dover, DEN109PBBennedsen Rosa Fadia Gabriel · Aventura, FLN109RASunny Sky LLC · Stacyville, IAN109SFHeli Assets LLC · Mesa, AZN109SJCarmona Cristobal Pelaez · Laredo, TXN109TGTwin Rotors Flying Circus LLC · Port Orange, FLN109USU S Helicopters Inc · Marshville, NCN109WGDodson International Parts Inc · Rantoul, KSN109WHTre Aviation Corp · Wilmington, DEN109WJL S Service Corp · Wilmington, DEN109XPNational Test Pilot School · Mojave, CAN109ZTValiair Lc Trustee · Casper, WYN10AJEl Aero Services LLC · Elko, NVN10BLLeon Helicopter One LLC · Miami, FLN10CCSmith Kord S · Salmon, IDN10KXWhirly Leasing Inc · Richvale, CAN10LESlws LLC · Missoula, MTN10MSKas Enterprises LLC · Lewes, DEN10SPState Of Kentucky · Frankfort, KYN10TVHelicopters Inc · Cahokia, ILN10XVHelicopters Inc · Wilmington, DEN110DJLife Flight Network LLC · Aurora, ORN110LTLt Aviation LLC · Louisa, KYN110WGMeshoppen Air LLC · Tunkhannock, PAN111BVOceanside Vertical Express LLC · Canaan, NYN111GHGuardian Helicopters Inc · Fillmore, CAN111HFPlane Fun Inc Tr Trustee · Snellville, GAN111PMTri Rotor Spray And Chemical · Ulysses, KSN111SPState Of Michigan · Lansing, MIN112EPMarks Aviation Group LLC · Lafayette, LAN112LPRanger Aviation Leasing LLC · Wilmington, DEN113AEAir Evac Ems Inc · O Fallon, MO
Back to AD 2002-20-05