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.
N60756Vanjara Obaid U · San Ramon, CAN60757Follman Aviation LLC · Waterport, NYN6075FSky West Aviation Inc Trustee · Albuquerque, NMN6075GTango Aviation Rentals LLC · Austin, TXN6075JLowrance Kathleen C · Plano, TXN6075KWilliams Todd D · Perry, UTN6075RNelsn Hans A · Sergeant Bluff, IAN60761Code 1 Flight Training LLC · Canton, TXN60766Congdon Douglas J · Fairbanks, AKN60767Turnier Mikel W · Middletown, NYN60768Mcgee Jacob Quinton · Anchorage, AKN60769Del Duca Frank J · Bethel, MEN6076ABack Daryl · Stephenville, TXN6076BBouchard Timothy · Valdez, AKN6076FCancro J Chriss · Enumclaw, WAN6076GColbert Farms Inc · Davenport, WAN6076RAdvanced Targeting Solutions LLC · Perkasie, PAN60773Edwards Air LLC DBA · Raleigh, NCN6077AHall James E III · Lumber Bridge, NCN6077JLove To Fly LLC · Myrtle Beach, SCN6077KRocha Adrian M · Rosharon, TXN6077RCultra Daniel L · Rochelle, ILN60781Two Birds One Bear LLC · Upper Arlington, OHN60787Kenses Daniel T · Stuart, FLN6078ASnell Jeffrey D · Inver Grove Hghts, MNN6078ROancea Traian · Oakdale, CAN60790Jenkins Berry E · Bell, FLN60793Registered aircraftN60796Lemanski Thomas A · Port Townsend, WAN60797Portland Metro Aviation & Flying Club · Portland, ORN60798Hjl Farm Inc · Dagmar, MTN6079ARegistration Pending · Hartford, SDRegistration pendingN6079BRift LLC · Union, MON6079F6079 Foxtrot Inc · Dover, DEN6079JSmith Richard D II · Luthersville, GAN6079TFookes Raymond R · Lenoir City, TNN607MLIprop LLC · Palm Beach Gardens, FLN60800Edens Harald E · Socorro, NMN60802Smith Jay · San Andreas, CAN60808Foster William L · Waco, TXN60809Van Bortel Aircraft Inc · Arlington, TXN6080FKonecny Walter O · Draper, UTN6080JRidgewood Corp Inc · Orangeville, PAFirst renewal noticeN60818Bailey James C · Drummond Island, MIN6081ABoykin Bobby · Brandon, MSN6081RWatler John L · Brazil, INN60822Hawkinson Paul M · Grand Rapids, MNN60825Namtvedt Erik L · Wasilla, AKN6082KCarlton David L · Galesburg, ILN60830Ace Aviation Seminars LLC · Armuchee, GA
Back to AD 79-10-14 R1