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.
N705TDFlight Gear Aviation LLC · Pickerington, OHN705UChristiansen Aviation LLC · Wilmington, DEN706Old Aire LLC · Bellingham, WAN70607Walsh Dennis A · Dakota City, NEN70609Gospel Ministries International · Mc Donald, TNN7060AWalker Jonathan S · Council Bluffs, IAN7060EBrenner Valerian · Port Saint Lucie, FLN7060QPilot In Command Academy Inc · Miami, FLN7060SDygas Pauel · Pomerene, AZN70616Washburn Darlene J · Newberg, ORN70617Mcnutt John W · Seattle, WAN70618Allen Steven P · Flagstaff, AZN7061QMccutcheon Henry C · Frankfort, KYN7061SDirar Farras S E · Sackets Harbor, NYN7062Carvagno Lawrence · Trinity, ALN70625Resong Joseph J · Garden Grove, CAN7062GNorthwoods Aviation LLC · Eagle River, WIN7062MWieler Jay H · Nome, AKFirst renewal noticeN7062SPrecision Aerospace Corp · Sarasota, FLN7062TJardd Inc · Lorain, OHN70632Galion Air Inc · Galion, OHN70633North County Flying Club · Tehachapi, CAFirst renewal noticeN70634Sowry Myron E · Phillipsburg, OHN70635Sitatunga Springs LLC · River Hills, WIN7063ASexton Forest · Eagle Point, ORN7063GL A H Eickhoff Farms Inc · Falls City, NEN7063QCarver Clarence K · Lutz, FLN7063TMorris Coady C · Russell, KSN70649Carroll Aviation Inc · Carroll, IAN7064ASelby Joshua F · Condon, ORN7064EBolognese Joseph · Las Vegas, NVN7064SCuddington Mark E · Puyallup, WAN70651Sale Reported · Lakewood, COSale reportedN70655Kusterer James E Jr · Nampa, IDN70657Cobra Kai Inc · Wichita Falls, TXN70658Vroom David H · Oro Valley, AZN7065AJahnke Michael D · Wichita, KSN7065GAden David L · Keenesburg, CON7065JAmendt Inc · Sedgwick, CON7065MPamair Inc · Wilmington, DEN7065TRegistered aircraftN7066ANewton Consulting & Engineering Inc · Tucson, AZN7066EBarnes Stephen W · Mustang, OKN7066FLamb Barry J · Moran, KSN7066GSwindle Don K · Collinsville, TXN7067AWhitemire Jospeh A · Soddy Daisy, TNN7067BMcdonald John M · Lyons Falls, NYFirst renewal noticeN7067E5 Am Equipment LLC · Casper, WYN7067GAngelle Kelli R · New Roads, LAN7067TSmith Roy Harold · Whiteville, NC
Back to AD 79-10-14 R1