AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N6913GAshland Jeffrey C · Spirit Lake, IAN6913XEllis Mark C · Rogers, ARN6914EDodge Donald A · Dupuyer, MTN6914FStephens Nicholas J · Santa Rosa, CAN6914XMagee Wayland S · Agency, MON6915ACraig Linda I · East Freetown, MAN6915FTillison Glenda L · Cameron Park, CAN6915SCochran William J · Williamson, GAN6915XWitkowski Terrance G · Winamac, INN6916ABloyer Emery · Fennimore, WIN6917ERegistration Pending · Lowell, MIRegistration pendingN6917SFly 17 Sierra LLC · Tampa, FLN6917XSchumacher Terry L · Wilson, WIN6918Sutherland Robert · Bowling Green, KYN6918ALarson Gary W · Fort Worth, TXN6918XHackbarth Ryan J · Zimmerman, MNN6919GSeats Frank R · Bristol, VAN6920EShoemaker Logan · Ruston, LAN6920XEge David D · Mount Horeb, WIN6921FAndrade Alexander S · Pleasant Grove, UTN6921GWard Michael J · Carnesville, GAN69220Green Gary E · Cotter, ARN6922XIowa Military Aviation Heritage Museum · Ankeny, IAN6923EBailey Charles T · Carthage, TXN6923SEpley Kennith W · Ladonia, TXN6924AHuempener Gary R · Cato, WIN6924EThomas Charles · Marathon, IAN6924XAshby Jimmie Thomas · Germanton, NCN6925FRzucidlo Trevor A · Dayville, CTN6925XAdlard Thomas · Spokane, WAN6926ATrident Aviation LLC · Kalispell, MTN6926ECheney Douglas A · Windsor, CON6926GWelling Michael J · Milltown, WIN6927ASmith James C Jr · Fayetteville, GAN6928ESmith Richard B · Renton, WAN6928MJohnson Mark D · Onondaga, MIN6928SPoling Brett Tyson · Saint Francis, KSN6928XN6928x LLC · Sandpoint, IDN6929AWadsworth Curtis D · Sierra Vista, AZN6929FRyberg Keith C · Portales, NMN6930AStewart Donald M · Vulcan, MIN6930FWright Dale D · Wallace, KSN6931GWoody Eric · Candler, NCN6931XDanford Gary R · Columbus, MSN6932AAthey Jerry Jeff · Alvin, TXN6932GRonald O Holcomb LLC · Republic, MIN6933ERulo Michael L · Westcliffe, CON6933GAltomari Richard · Pittsburgh, PAN6934SLet There Be Flight LLC · Portage, MIN6934XLunar Aviation Services LLC · Owasso, OK
Back to AD 94-05-05 R1