AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N3076XOlesen Wayne O · Troy, IDN3077EBlackhawk Holding Corp · Wilmington, DEN3077FBlake Jason E · Shreveport, LAN30785Colleran Michael · Suamico, WIN30786Gettys John E · Cabool, MON30789Gccs Corporation · Danville, PAN3078JRobertson Crop Dusting Service Inc · South Haven, MIN3078XRogers Matthew J · New Paltz, NYN30790Cammarato Thomas Angelo · Aguila, AZN30794Wilkinson Thomas W II · Spring, TXN3079FMackay Chadd P · Spokane Valley, WAN3079JAdvantage Aviation Services LLC · South Saint Paul, MNN307BMBow Mac Aviation LLC · Spring Lake, MIN307CFSchwarzenberg Johannes · Helena, MTFirst renewal noticeN307CREmpire Of Stars Commercial And Residential Real · Downey, CAN307FMNorris Aviation LLC · Mansfield, TXN307GHollister Jet Center Inc · Hollister, CAN307GRJ & D Flying LLC · Sand Point, AKN307JHRoundy Joseph · Three Forks, MTN307KMMcphaill Kevin · Visalia, CAN307PRDog Is My Copilot Inc · Jackson, WYN307SPSheridan Pilots 307 LLC · Sheridan, WYN30800Congdon Carl J · Manley Hot Springs, AKN30805Joshua Apodaca · Glendale, AZN30807Edwards Garland U · Midlothian, VAN3080ESky Safety Inc · San Antonio, TXN3080JShafovaloff Thomas E · Scottsboro, ALN3080QN3080q LLC · Phoenix, AZN3080XN3080x LLC · Greenwood Village, COFirst renewal noticeN3080YHd Aviation LLC · Birch Tree, MON3081EWilliams Gregory B · Verona, WIN3081FHenion John D · Trumansburg, NYN3081SSproul Wendell C · Hermon, MEN30824Rude Allen · Mcville, NDN30826Grundy James W · W Greenwich, RIN30828Lary Leanne K · Thousand Oaks, CAN3082EAirgo Inc · Centralia, ILFirst renewal noticeN3082FHoffman Allen C · Anchorage, AKN3082JLandrum Craig · Vinita, OKN3082QAttaalla Maged A · Torrance, CAN3082UArmstrong Geoffrey Peter · Las Vegas, NVN3082YSappington Steven R · Redondo Beach, CAN30835Landis Wayne G · Bellingham, WAN3083FFree Richard D · Clearwater, KSN3083SPrather David H · Gig Harbor, WAN30841Mulliken Jerry A · Nickerson, NEN3084JDorn Caleb · Bossier City, LAN3084SHigh Exposure Inc · Wilmington, DEN3084YWasatch Industries LLC · Ogden, UTN30851Cohorst Jason P · Shawnee, KS
Back to AD 97-01-13