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.
N803MWMowotech Inc · Boca Raton, FLN803SPDodson International Parts Inc · Rantoul, KSN8040FWingfield Kyle M · Leesburg, GAN8040SNew Flight LLC · Dublin, VAN8040XMj Coop LLC · Sylva, NCN80414Garn Darrell L · Palmetto, GAN80419Korona Lawrence K · West Paterson, NJN80421Kuder Kyp E · Rogers, NDN80425Fellows Roy H · Augusta, KSN8042FFlying Hawks Inc · Palmyra, WIN8042SBanning Braden L · Pleasant Hill, IAN8042VSale Reported · Watford City, NDSale reportedN80436N80436 LLC · Columbia, MSN80439Oklahoma State University · Stillwater, OKN8043GConnor Robert L · North Little Rock, ARN8043SLund William R · Escondido, CAN8043XStrandberg Kevin L · Pennock, MNN80440Rockey John · Jupiter, FLN80442Washburne Seth P · Dallas, TXN80449Davis Lawrence J Jr · Wasilla, AKN8044BAshley Ken E · Maiden, NCN8044GTml Services LLC · The Villages, FLN8044LOverton Larry D · Hermiston, ORN8044ZLever Samuel C · Udall, KSN8045Mcclure Richard A · Edna, TXN80454Tadao LLC · Tucson, AZN80456Barash Geva S · Ashland, MAN80458Kolpack Glenn H · Sonora, CAN8045ASalter James M · Crested Butte, CON8045LAmonett Rodney · Abilene, TXN8045QEcho Bay Corporation · Bow, WAN8045VGreater Houston Soaring Assoc · Needville, TXN80469Hetherly Bryce D · Clintondale, NYN8046BAnderson Charles D · Fairbanks, AKN8046SHolmes Gerald P · Billerica, MAN8046VSt Bernard Parish Police Jury · Chalmette, LAN8046ZBest Auto Sales LLC · Plummer, IDN80470Coddiwomple LLC · Newberg, ORN80471Dairy Air Inc · Wyoming, PAN80472Simons George Trustee · Bouse, AZN80475Texas Southern University · Houston, TXN80476Sky Roamers LLC · Columbus, NEN8047BGuidry Janice C · Mechanicsville, VAN8047ECivil Air Patrol Inc · Maxwell Afb, ALN8047FPoole Terrell W · Rigby, IDN8047XFitzgerald Jeff D · Smithfield, UTN8047ZBooth James L · Bozeman, MTN80483Harrell Matthew J · Grand Haven, MIN80484Mor Aviation 172m LLC · Gaithersburg, MDN80486Romoser Carey E · Simpsonville, SC
Back to AD 79-10-14 R1