AD 75-25-03
Registered aircraft · 563
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-25-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-25-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-25-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-25-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.
N1555XShelton Brad · Wildwood, MON1570XTmstarservices LLC · Lewes, DEN157BJHolm Brian · Buckley, WAN162BWSimply Living LLC · Fort Myers, FLN181FMLuse Otis · Lago Vista, TXN1839HFly 172n LLC · Peoria, AZN1863HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN189MLStrobe Aviation LLC · Columbia, SCN18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal noticeN18TPPotter Todd J · Warrens, WIN1989HHogan Thomas J · San Diego, CAN198TBHonore Breen Aviation LLC · Allegan, MIN19BAgricultural Investors LLC · Jacksonville, FLN19MBDg Aircraft LLC · Lemont Furnace, PAN19TPTwv Air LLC · Ewing, NJN200SBSoaring Hawk Aviation LLC · Dexter, MIN2082KGolden 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, CAN212MLSeneca Aviation Inc · Wilmington, DEN21382Rodriguez Carlos Mendoza · Paramount, CAN2159SOutfront Aviation LLC · Merritt Island, FLN2166MMiller Harry B · Fisherville, TNN21788Kenco Associates Inc · Ashland, KYN2190KArnold Mark W · Columbus, OHN21QSParsons 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, NEN22PWGoldsboro Flight Club LLC · Faison, NCN234FYVee Two Inc · Merritt Island, FLN234TGAvionicos Corp · Sarasota, FLN236CFGriswold Joshua P · Los Angeles, CAN23JCJet & Rotor Aviation LLC · Sacramento, CAN246BMBlue Oasis Flight Support · Tamarac, FL
Back to AD 75-25-03