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.
N6782HJb Aviation Management Inc · Wonder Lake, ILN6782RReavis Paul B · Gatesville, TXN6783RHarness Jesse J · Peoria, AZN6784AAtlantic Rotors LLC · Saint Inigoes, MDN6784ESwedberg Randy M · Kingman, KSN6784RVolk Kenneth L · Waskom, TXN6785MRocerick Dean G · The Dalles, ORN6785RRood Enterprises LLC · Livingston, TXN6785SSchmidt Gary C · Sunrise Beach, MON6786ARutledge Brett B · Yuma, CON6786FBeitz Norman Roy · Quitman, TXN6787HGordon Caleb J · Waukesha, WIN6787RJensen Leland · Idaho Falls, IDN6788MEs Limited · Edmond, OKN6789AChris Fuher Flight Instruction LLC DBA · Townsend, MTN6789EHeinen Avionics LLC · Adrian, MIN6789KDrc Equipment LLC · Caldwell, IDN6789MPlane Services LLC · Twin Falls, IDN6789RDodson International Parts Inc · Rantoul, KSN678AAWings Over Texas Holdings LLC · Denton, TXN678GHHamilton Gilbert R · Leesburg, VAN678JBSierra Flyers Inc · Incline Village, NVN678KPalm Steven · Madera, CAN678NDUnd Aerospace Foundation · Grand Forks, NDN678RBBoldflight LLC · Bargersville, INN678RMLaw Roger Jay · Franklin, INN678SPFreed Bryan S · Norfolk, VAN678WLanghoff John A · Yoakum, TXN678WWFly Cessna LLC · Peoria, AZN6790ALaurel 406 Aero · Billings, MTN6790GMartin Christopher G · Monessen, PAN6790SHildreth Jon R · Spencer, WVN6792FPatton Aviation LLC · Billings, MTN6792MHouck Mary M · Fish Creek, WIN6792RKenley Fredrick C · Palmer, AKN6792SJohnston Robert G · Rose Hill, KSN6793AJones Jeffrey D Trustee · Elida, OHN6793EBig South Fork Aerospace LLC · Pine Knot, KYN6793FOgden John T · Meridian, IDN6793GExecutive Flight Institute LLC · Murrieta, CAN6793RDelevie Mark Y · Tucson, AZN6794EWalls Jerry L · Hawley, TXN6794GLawson Kurt J · Melbourne, FLN6794HPs N6794h LLC · Green Bay, WIN6795AKelley Aviation Services Inc · Halifax, PAFirst renewal noticeN6796AAjer Richard L · Herriman, UTN6796EBlain Kyra · Conroe, TXFirst renewal noticeN6796GLyon Scott T · Wellsville, KSN6796HAmelia Reid Aviation LLC · San Jose, CAN6796SRegistration Pending · Lawrence, KSRegistration pending
Back to AD 79-10-14 R1