AD 76-01-01
Registered aircraft · 152
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:76-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-01-01')
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:76-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-01-01') 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.
N6051JRobison David · El Dorado, ARN6056JAchord James D · Decatur, ALN6058JWhitson Freddie B · Llano, TXN6065JBrown Charles A · Boise, IDN6067JSale Reported · Ephrata, WASale reportedN6075JLowrance Kathleen C · Plano, TXN6080JRidgewood Corp Inc · Orangeville, PAFirst renewal noticeN6084JHatloy Mark · Drayton, NDN6087JTexas Youth Flight Experience Foundation · Boerne, TXN6096JCurrivan Robert B · Fort Mohave, AZN6098JHall David K · State College, PAN6099JVincent David R · Hartley, TXN6120FHickman Robert J · Canby, ORN6135FJr Imaging Logistics Inc · Pasco, WAN6140FFluno John I · San Rafael, CAN6145FAlpha Bravo Aviation LLC · Trophy Club, TXN6146FHeppner Sebastian · Fishers, INN6155FHalladay Roy · Erie, CON6157FLa Placa Peter · Lake Havasu City, AZN6167FJohnson Susan J · Chelan, WAN6188FSky High Adventures LLC · Wilmington, DEN632EHHuddleston Edward L · Oaktown, INN634EHEd-Air Inc · Oaktown, INN6436FOrnelas Miguel A · Tucson, AZN6438FRegistration Pending · Everett, WARegistration pendingN6503FStockton Ketron J · Bulls Gap, TNN773WSPerez Valentino · Sinajana, GUN7837FObrien Daniel N Jr · Bellevue, WAN7949FMaciol Michael W M D · Pelham, NYN8123LShippee Norman J · Foster, RIN8189FArchuleta Michelle L · Las Cruces, NMN8305MGossage Terrence L · Port Angeles, WAN8310MFlying Engineers Inc · Indianapolis, INN8314MDavid Ari C Esq Trustee · San Diego, CAN8323MBean Danny O · Mulkeytown, ILN8324MKnox John D · Broken Arrow, OKN8327MArch Frederick W Jr · Lake Placid, FLN8328MLuker Victor R Jr · Terrell, TXN8336MStarz Align Aviation LLC · Marshfield, WIN8340MBlake Larry Q · Suwanee, GAN8341MKab Aviation LLC · Cassopolis, MIN8342MStreeter Wyatt E · Hanford, CAN8343MDuke Kay L · Darrouzett, TXN8345MBryant William G · Kenai, AKN8349MMarker Nathan E · Amherst, OHN8351MWheaton Eric J · Gig Harbor, WAN8352MOak Ridge Flyers Inc · Oak Ridge, TNN8355MRcs Services LLC · California, MDFirst renewal noticeN8356MSporie George F · Marinette, WIN8360MOld Goat Aviation LLC · Naples, FL
Back to AD 76-01-01