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.
N6998APincheon Reginald · La Vergne, TNN6998GAviation Trust Company LLC Trustee · Oklahoma City, OKN6998SFowler John C · Scott Depot, WVN69995Hillis Larry Gregory · Pickens, ARN6999AHartzler Jeffery A · Rittman, OHN6999EMusgrove Jimmy Wayne · Delta Junction, AKN6999FHabibi Airlines LLC · San Juan, PRN6999MAbonil Ty · Philadelphia, PAN6999RWorswick Dwight D · Yuba City, CAN699CBBig Skylands Aviation LLC · Succasunna, NJN699CPCivil Air Patrol · Maxwell Afb, ALN699EEMathes Jay B · Ridgecrest, CAN699JGJaymar Aviation LLC · Flagstaff, AZN699JHLazy Ta Legend Aircraft LLC · Wilmington, DEN699JMSky West Aviation Inc Trustee · Albuquerque, NMN699LPFrg III Inc DBA · Lincoln Park, NJN699WWWallis Warren · Barstow, CAN699XMBas Part Sales LLC · Greeley, CON69ACKendel Stephen George · Colbert, WAN69AMMargitan Allan R · Nine Mile Falls, WAN69BNSky West Aviation Inc Trustee · Albuquerque, NMN69CHTexarkana Flying Club Inc · Texarkana, TXN69DREsi Aviation LLC · Lakewood, CON69ELLewis Ethel M · Castro Valley, CAN69EMSmith Michael A · Willows, CAN69FZDeweese Michel J · Rockvale, TNN69GVSaltz Clyde · Soldotna, AKN69HGPlane Fun Inc Tr Trustee · Snellville, GAN69HPHigh Performance Aircraft LLC · El Cajon, CAN69HZU206 Ice LLC · Pompano Beach, FLN69LEEle Motorsports LLC · Dover, DEN69MGArizona Active Air LLC · Yuma, AZN69PRAero Inventory LLC · Monroe, GAN69RLLivingston Robin L · Vail, AZN69RMDicicca Yolanda L · BitontoN69SInternational Air Services Inc Trustee · Carson City, NVN69TRZg Ltd · Green Cove Springs, FLN69UTAux N69ut LLC · Portland, TXN69WKirby Mitchell E · Gualala, CAN69WAKeystone Aerial Surveys Inc · Philadelphia, PAN69WESlate Kevin Dwayne · Bell Buckle, TNN69ZBSpringfield Flying Service LLC · Columbia, CAN6ABCenterline Holdings Inc · Camden, DEN6AWH & H Hanger LLC · El Campo, TXN6BEZephyr Enterprises Inc · Wilmington, DEN6BKAerovana LLC · Caldwell, IDN6CEQuinn Paul R · Southlake, TXN6CRJ R Systems LLC · Kenedy, TXN6CSJj Ventures LLC · Billings, MTN6CVEubanks Edward · Tulsa, OK
Back to AD 79-10-14 R1