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.
N739ZCP&B Aviation LLC · Watkins, CON739ZGR & R Aero Services Llcc · Eden Prairie, MNN739ZHFreeflight Aviation LLC · Allentown, NJN739ZLLefebvre Jeffrey S · Kaneohe, HIN739ZNOur Jett LLC · Englewood, CON739ZPBlue Sky Aviation LLC · Watkins, CON739ZSPryor James A · Bottineau, NDN739ZUMelbourne Flight Training LLC · Melbourne, FLN739ZWHolladay Aviation LLC · Jacksonville, FLN739ZXN739zx Flying Association · Kent, WAN739ZZR & R Aero Services LLC · Eden Prairie, MNN73ALHefel Lori A · Wichita, KSN73BJJewett Brandon M · Brighton, CON73BTDragging Tails LLC · Colbert, GAN73CHAb Prop Plane II LLC · Metairie, LAN73CQHillesheim Steven T · Grass Valley, CAN73CYRti Fabrication Inc · Plains, MTN73DAFlying Alaska LLC · Anchorage, AKN73EKOgrin Kirk W · Bigfork, MTN73ESWilmington Trust Co Trustee · Wilmington, DEN73FRWayman Luy LLC · Weston, FLN73GJSkydive Greene County Inc · Xenia, OHN73GLG & N Enterprises LLC · Sparks, NVN73GMPrice Roger Paul · Punta Gorda, FLN73JJJj Ventures LLC · Billings, MTN73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidN73LHerald Gregory L · Coatesville, INN73LLT3 Aviation LLC · Oak Point, TXN73LT302 LLC · Anchorage, AKN73MHRainier Flight Service LLC · Renton, WAN73MRMarshall Edward G Trustee · Saint Clair, MIN73MSJohnson Kevin N · Bethpage, NYN73PRegistered aircraftN73PPArew Aviation LLC · San Tan Valley, AZN73PWWarren John M · El Paso, TXN73RBTurbo Centurion LLC · North Salt Lake, UTN73RJRichard Kent A · Sunset, LAN73SC73sc Owners Group Inc · Torrance, CAN73TAWorks Design Group Inc · Hammondsport, NYN73TFKlanchar Flying LLC · Benton, ARN73TLTeaff Leslie T Trustee · Russellville, ARN73TPTop Aircraft Leasing LLC · Wilmington, DEN73WPGemini 3 LLC · Cleves, OHN740United States Department Of Interior · Boise, IDN7400AHarrop Brian C · Mesa, AZN7400M7400m Air Inc · Auburn, ALN7400XLandrush Construction LLC · Fairview, OKN7401ECosta Air Service LLC · Painted Post, NYN74022Braatz Cannonf · Bend, ORN7402QRichs Alaskan Flying Adventures LLC · Wasilla, AK
Back to AD 79-10-14 R1