AD 75-20-03
Registered aircraft · 735
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:75-20-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-20-03')
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:75-20-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-20-03') 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.
N18TPPotter Todd J · Warrens, WIN1972BPerformance Aircraft Sales Inc · Lincoln, NEN1989HHogan Thomas J · San Diego, CAN198TBHonore Breen Aviation LLC · Allegan, MIN19BAgricultural Investors LLC · Jacksonville, FLN19MBDg Aircraft LLC · Lemont Furnace, PAN19TPTwv Air LLC · Ewing, NJN1JDAero Aircraft 10 LLC · Jacksonville, FLN200SBSoaring Hawk Aviation LLC · Dexter, MIN200WSSierra Juliet Nm LLC · Santa Teresa, NMN202KASkybrothers LLC · Scottsdale, AZN2082KGolden Ranch Aviation Inc · Schriever, LAN2085MVee Two Inc · Merritt Island, FLN20TPFrascino Anthony · Johns Creek, GAN2106EBas Part Sales LLC · Greeley, CON21160N21160 LLC · Sanford, FLN2118HMcfadden Derek C · Lebanon, OHN2119CClakley Gordon Nathan · Clayton, CAN211SKBon Investment Holdings LLC · Zephyrhills, FLN212MLSeneca Aviation Inc · Wilmington, DEN21382Rodriguez Carlos Mendoza · Paramount, CAN2159SOutfront Aviation LLC · Merritt Island, FLN2166MMiller Harry B · Fisherville, TNN21788Kenco Associates Inc · Ashland, KYN2190KArnold Mark W · Columbus, OHN219TGXin Han Aviation LLC · Atwater, CAN21QSParsons Ray · Abilene, TXN21YCPattillo John · Cocoa, FLN22042Lemish Michael · Cedar Hill, TXN2205WSasnak Inc · Wichita, KSN2218UF & D Leasing Limited · East Liverpool, OHN2227WAb Christenson Holdings LLC · Bluffdale, UTN2228UPeak Leasing LLC · Anchorage, AKN2239D41 Investments Gp LLC · Sinton, TXN223XSaleem Sandhu M · Santa Clara, CAN2240DOhnback Ulf · Spokane, WAN2244BIntegrated Milk LLC · Dimmitt, TXN227ALGarbar Organization LLC · Duncan, SCN2284MGulf Coast Air LLC · Lakeland, FLN2285MBowman Field Aviation Club Inc · Louisville, KYN2298QGalaxy Enterprises LLC · Holdrege, NEN22JLWasson James L · Tyler, TXN22PWGoldsboro Flight Club LLC · Faison, NCN234FYVee Two Inc · Merritt Island, FLN234NCIal Corp · Lewes, DEN234TGAvionicos Corp · Sarasota, FLN236CFGriswold Joshua P · Los Angeles, CAN23JCJet & Rotor Aviation LLC · Sacramento, CAN246BMBlue Oasis Flight Support · Tamarac, FLN2486UGuardian Flight LLC · South Jordan, UT
Back to AD 75-20-03