AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N65275Registered aircraftN65276Christiansen Aviation LLC · Wilmington, DEN65279Ferrara Joseph Vincent · Port Saint Lucie, FLN6527ALivingston Thaddeus A Trustee · Chugiak, AKN6527ETaylor Carey A · Rainier, WAN6527RAmerican Aviation LLC · Yuma, AZN6527SHirkala Ronald R · New Cumberland, WVN6528TRogers Brian D · Pacific, MON6528VFischer Heather A · Merrimack, NHN65290So Cal Leasing LLC · El Cajon, CAN65295Northwoods Air LLC · Orono, MEN6529DG Force Advantage LLC · Lewes, DEN6529FRising Aviation LLC · Prairieville, LAN6529SDemott Steve · Covina, CAN6529TCarncross Jerome W · Arlington, WIN6529VAhlhorn Travis Wayn · New Braunfels, TXN6529XOvando Jorge · Sherman Oaks, CAN6529YBbd Lynch Family Lp · Houston, TXN652CFGuenther Daniel R · New Bern, NCN652EPChristiansen Aviation LLC · Wilmington, DEN652FCFlorida Department Of Agriculture And Consumer Svc · Tallahassee, FLN652MAAbove And Beyond Aviation LLC · Austin, TXN652NDInternational Air Services Inc Trustee · Carson City, NVN652PASmn Investments Inc · Greeneville, TNN652RHTwohy David S · Osceola, WIN652SPChristiansen Aviation LLC · Wilmington, DEN652SRBracy Rodney E · Middleville, MIN65306Bullet Power Brokers Inc · Stuart, FLN6530FRaw Racing Inc · Puyallup, WAN6530HWagons West LLC · Myrtle Beach, SCN6530MTschann David M II · Yorba Linda, CAFirst renewal noticeN6530RByers Travis M · Villa Rica, GAN6530YDelgado Gonzalez Hector · San Diego, CAN65311Mustang Sally Aviation LLC · Camden, SCN6531GGalavis Eduardo · Miami, FLN6531RBruno Gennaro S · Lewes, DEN6531SHatcher Mark F · Aloha, ORN6531XSchwartz Alan M · Hurleyville, NYN65324Bickerstaff Mike · Port Orange, FLN65328Lingyun LLC · Winter Garden, FLN65329Advanced Aviation Group LLC · Frederick, MDN6532ERegistration Pending · Maize, KSRegistration pendingN6532FCouch Walter Jack · Patterson, LAN6532JGarner Aviation LLC · Tampa, FLN6532NN6532n LLC · Sioux Falls, SDN6532TRich Jay A · N Salt Lake, UTN65330Flight Training Aircraft LLC · Wilmington, DEN65331Maxxum Financial Group Inc · Destrehan, LAN6533FMoore William H III · Deer Park, WAN6533TCrawford Daniel G Trustee · Dryden, MI
Back to AD 79-10-14 R1