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.
N98251Wings Over Texas Holdings LLC · Denton, TXN9825GKanawha Aviators LLC · Bancroft, WVN9825TLong Duane C · Baskin, LAN98264Civil Air Patrol Inc · Maxwell Afb, ALN98271Mastin Aviation Inc · Pasadena, MDN9827GSpencer Jeffrey · Capistrano Beach, CAN9828ETa Wellner Group LLC · Lake Oswego, ORN9828JIcarus Copters LLC · Lancaster, CAN9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLN9828TArts Donald W · Lincoln, CAN9828XPathfinder Aero Services LLC · Sheridan, WYN9829HWright Steven · Shelbyville, TNN9829JInflight Corp · Chaffee, MON9829MRyan Air Inc · Anchorage, AKN9829TGeske Kenneth A · Thief River Falls, MNN982BRThompson H S Trustee · Oakdale, CAN982BTWings Over Texas Holdings LLC · Denton, TXN982CPCivil Air Patrol Inc · Maxwell Afb, ALN982SFBauermeister Matthew · Lake Tapps, WAN982SKRowe Andrew L Jr · Hope, MEN982SPScott Kenneth C · Erie, CON98306United States Air Force Owner · Usaf Academy, CON9830GGonzalez Nicolas · Naples, FLN9830JJohnsen Christian · Big Bear Lake, CAN9830TPoe Joshua J · Peculiar, MON9830VLeading Edge Flight Academy LLC · Bend, ORN9830XWard Todd · Corona, CAN9831GStarr David · Mount Prospect, ILN9831JHaddix Stanley D · Hagerhill, KYN98323Civil Air Patrol Inc · Maxwell Afb, ALN98326Lum Barnett K · Temple City, CAN9832JWolfe William Keith · Greenbrier, ARN9832XAlbert Bryan W · Palmer, AKN9833HMccool Air Service Inc · Mc Cool Junction, NEN9833VMartin Kendall L · Wills Point, TXN9834GNielson Douglas W · East Troy, WIN9834LCivil Air Patrol Inc · Maxwell Afb, ALN9834THulbert Douglas S · Santa Maria, CAN9834XPemberton Ryan A · Valleyford, WAN98352Civil Air Patrol Inc · Maxwell Afb, ALN98354Jin Jin Aviation LLC · Anchorage, AKN9835GPiedmont Flight Inc · Winston Salem, NCN9835JCrooks Curtis L · Truckee, CAN9835TVfr Ltd · Wilmington, DEN9836BSoulek Paul A · Spearfish, SDN9836GSchafhausen Mark G · Spokane, WAN9836HDouglas County Land Title Co · Douglasville, GAN9837GSouther Field Aviation Inc · Americus, GAFirst renewal noticeN9837HChristmas Aviation LLC · Pace, FLN9837LIal Corp · Wilmington, DE
Back to AD 79-10-14 R1