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.
N681DCDoodle Air LLC · San Jose, CAN681DWSunrise Aviation Inc · Ormond Beach, FLN681EREmbry-Riddle Aeronautical University Inc · Prescott, AZN681MAChristiansen Aviation LLC · Wilmington, DEN681RLWeatherby Thomas M · Rcho Sta Marg, CAN6820GJensen Eric Gunnar · Ogden Dunes, INN6821AArmiger Scott Linwood · Holly Springs, NCN6821EPriest Justin E · Arlington, WAN6821GMueller Carla I · Lexington, SCN6821XTudorani Vincenzo C · Las Vegas, NVN6822AStewart Brock Allen · Bartlett, TNN6822GKnot Enough Airspeed LLC · Oshkosh, WIN6822MSunnysideup LLC · Las Vegas, NVN6823AWilliams Daniel H · Fort Mcdowell, AZN6823HClay Howard C II · San Francisco, CAN6823XTipton Wendell D · Anchorage, AKN6824AChristenson Robert E · Anacortes, WAN6824RSquadron 5 Inc · Saratoga, CAN6825ABarker Jason · Hampton Falls, NHN6825FKieffer Jason M · Omaha, NEN6825GRhodes Bruce A · Santa Cruz, CAN6826BDan Howard Aircraft Sales LLC · Tulsa, OKN6826ERudolphi Ben M · Valdosta, GAN6826FJeppesen Thomas L · Stanton, MIN6826GStar Voyages LLC · Kissimmee, FLN6827GBrooks Jeffrey C · Bridgeton, NJN6827XCalderon Daniel C · Castro Valley, CAN6828ESheppard Walter S · Troy, IDN6829ABaker Elbert W · Beckley, WVN6829ELay Steven K · New Vienna, OHN6829XZeegers Jozef · Bellingham, WAN682ADDuncan Brian · Indianapolis, INN682ASRegistration Pending · Stony Brook, NYRegistration pendingN682CPCivil Air Patrol · Maxwell Afb, ALN682DWMach X Aviation LLC · Weston, FLN682MAChristiansen Aviation LLC · Wilmington, DEN682PBoard Of Trustees Of Southern Illinois University · Carbondale, ILN682SBSundowners Inc · Fort Myers, FLN682SPHansell Stephen E · East Windsor, NJN6830ALange Cole K · Oglala, SDN6830EJackson Thomas M · Florissant, MON6830MJ & J Air LLC · Laurel, MSN6830RElizalde Carla Zankiz · Estero, FLN6831ASale Reported · Pullman, WASale reportedN6831HQuarry Jon C · Memphis, TNN6831MSouth Beach Adventure Sports LLC · Bald Head Island, NCN6832EStuebner David M · Delanson, NYN6832GAeronautical Technical Service Inc · Collierville, TNN6832RWheeler David G Jr · Chico, CAN6832XOwens Philip A · Maryville, TN
Back to AD 79-10-14 R1