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.
N8328BMontpelier Gary L · W Chazy, NYN8328JTreat James · Batesville, ARN8328MLuker Victor R Jr · Terrell, TXN8328SAhrens Scott W · Castle Rock, CON8328XPrevatt Richard T · Jacksonville, FLN8329A170 Adventures LLC · Hermosa Beach, CAN8329JWooley Eva · Hephzibah, GAN8329SWhite Plane LLC · Forest Lake, MNN8329UVolkman Ary D · Waunakee, WIN832CPCivil Air Patrol · Maxwell Afb, ALN832DCCase Daniel J · Spokane, WAN832EREmbry-Riddle Aeronautical University · Daytona Beach, FLN832KXHillsboro Aero Academy LLC · Hillsboro, ORN832MAState Of Wisconsin · Madison, WIN832PMCunningham William R · Broken Arrow, OKN832SRWallace John M · Canton, MSN832TCFour Pines LLC · Grand Rapids, MNN8330AKoliadko Joseph I · Luray, VAN8330BSilver Creek Aviation Services · Fort Worth, TXN8330TPerry Charlotte A · Pearland, TXN8331GWhitley Jonathan K · Goldsboro, NCN8331LMjl Investment Company Inc · Branchville, NJN8331TPerry Loren D · Hephzibah, GAN8331ZProbasco Mitchell L · Floydada, TXN8332GFlack Kevin S · Woolford, MDN8332SFlyit LLC · Camas, WAN8332UNeeley James L · Temecula, CAN8332XFlight Instruction Inc · Central City, NEN8333GInvestair LLC · Conway, ARN8333LLedford Daniel R · Granbury, TXN8333XBrownlee Mark B · Helena, MTN8334GAvcraft Inc · Columbus, NEFirst renewal noticeN8334LAirspeed Marketing Bravo LLC · Phoenix, AZN8334QVolatile Aero Ventures LLC · Boulder City, NVN8334SRecord John W · Apison, TNN8334THowe Danny · Camp Verde, AZN8334UBrown Matthew D · Hamptonville, NCN8334XBumgarner Tommy J · Stanley, NCN8335AHaack Forrest · Wasilla, AKN8335QFlying M Aviation LLC · Twin Falls, IDFirst renewal noticeN8335TRegistration Pending · Greenleaf, WIRegistration pending, pending cancellationN8335UFaour Douglas M · Macon, GAN8335ZLorentzen Aaron · Sterling, AKN8336ANicholson Scott V · Kalamazoo, MIFirst renewal noticeN8336JGoat Rodeo Aviation LLC · Leesburg, INN8336MStarz Align Aviation LLC · Marshfield, WIN8336SGroff Bradley Gene · Kingston, OKN8336TBernal Sergio R · Buckeye, AZN8337GSkyline Aviation Inc · San Angelo, TXN8337JGeorge Downer Flyers LLC · Aliceville, AL
Back to AD 79-10-14 R1