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.
N301ABCamber Aviator LLC · Miami, FLN3020KGhostwriter Airshows LLC · Hustonville, KYN3028NPryor Paul Robert · Carrollton, VAN303MMBrown Properties Of Ga Inc · Silver Creek, GAN3048YAeronautica LLC · West Hollywood, CAN3051XWagner Richard L · Conroe, TXN3054KFerguson David G · Woodbridge, VAN3057VBig H Transportation LLC · Traverse City, MIN30619Wrpl LLC · Mountain Brk, ALN30746Tribe Of Judah Motorcycle Ministries Inc · Humble, TXN313ASStephen Air LLC · Woodsfield, OHN314DFAerospace Trust Management LLC Trustee · Wilmington, DEN31530Wheeler Auctions & Real Estate LLC · Paris, MON31595Highlander Air LLC · Kalispell, MTN315EBBaas Holdings LLC · Lewes, DEN31629Wolff Aviation LLC · Cumberland, MDN31662Star Air Service LLC · Jacksonville, FLN31799Kaschmitter Enterprises Inc · Grangeville, IDN31913Southern Aircraft LLC · Valdosta, GAN31999Kealy Kevin · Las Vegas, NVN32015Rock Solid Aviation LLC · Lake Charles, LAN3229QHansen Ralph H Jr Trustee · Encinitas, CAN322FCFuego Enterprises Inc · Atlanta, GAN32456Bas Part Sales LLC · Greeley, CON32555Harvest Aviation · Wauchula, FLN32624Rio Aviation LLC · Wilmington, DEN32755Illinois Air Inc · Naperville, ILN32776Hutchison Ross C · Olathe, CON327CABurbano Oscar Sebastian · Greensboro, NCN32812Rottinghaus Kelly A · Dundee, MSN32863International Air Services Inc Trustee · Carson City, NVN32873Blundell Joseph B III · Belleville, ARN32959Hill Ryan D · Fresno, CAN32999Mil2atp Inc · Pikeville, NCN33012Leon Hinkle LLC · Fort Ashby, WVN33071Krogstad Bruce H · Milwaukee, WIN33144Weather Modification LLC · Fargo, NDN33156Bchr Aviation LLC · Boerne, TXN331VRaptor Airmotive LLC · Poplar Grove, ILN33303Kowalchyk Aviation Management LLC · Jasper, GAN33345Decker Timothy Daniel · Weatherford, TXN33360Synergy Transport LLC · Albany, ORN333EEHammons Tommy Frank · Atlantic Beach, FLN33401Innes Associates Insurance Services Inc · Safford, AZN33475Excelsior Solutions Inc · Pinehurst, NCN3353QTop Tier Truck And Trailer LLC · Amarillo, TXN33646646 Lease Holding LLC · Noblesville, INN33689Michair LLC · Omaha, NEN33724Mil2atp Inc · Pikeville, NCN33739Sale Reported · Crystal, MNSale reported
Back to AD 75-25-03