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.
N6017NGood Dog Leasing LLC · Vienna, VAN60183Hobbs Cody J · Omak, WAN60184Beaver Jason A · Reno, NVN60188N7010v LLC · Shelby, NCN6018AKing Andrew O · Newport, MEN6018BMcgrath Robert J · Simpsonville, SCN6018JGagnon Nels D · Globe, AZN6018KChristiansen Aviation LLC · Wilmington, DEN6018ZWarner Aviation Co · Council Bluffs, IAN60191Vogt Jeffrey D · Pleasant Grove, CAN6019AMitman John J · Florence, MTN6019BHaderlie Dustin D · Afton, WYN6019GAgaliotis Paul E · San Martin, CAN6019VChristiansen Aviation LLC · Wilmington, DEN6019XRuegg Charles E · Belfast, MEN601JRJumbo Gabrielle Inc · Wilmington, DEN601LSM&G Aircraft Management LLC · Englewood, CON601MBRegistration Pending · Ridgely, MDRegistration pendingN601NSchneider Bernard M · Battle Ground, WAN601PAMendenhall Michael L · Douglasville, GAN601RFPearson Nils C · Englewood, FLN602Watkins Arlo S · Chandler, AZN60203Mike Smith Aviation International Inc · Napa, CAN60205Garza Gilberto · Yuma, AZN6020ADanielson Donald J · Walla Walla, WAN6020F7l Air LLC · Franklin, TXN6020GBuckley Michael J · Billings, MTN6020NWatts Carl · Thousand Oaks, CAN6020RFly For Fun Aircraft LLC · Rockville, MDN60215Yoder Johnathan · Thompson Falls, MTN60217Grensky Stephen R · Spokane, WAN6021FB R S Leasing Inc · Wilmington, DEN6021KRegistration Pending · Grand Forks, NDRegistration pendingN6021MPark Rapids Avionics Inc · Park Rapids, MNN6021RBechtold Richard · Broadlands, VAN60224Arc Aviation LLC · Frisco, TXN60226Weston Jesse S · Spokane, WAN60227Ryan James E · Calvin, WVN60228Greene James W · Brunswick, GAN6022BArpino James E · Fairbanks, AKN6022RCunningham Gene Jr · Bristol, VAN6022THenderson Beverly A · Sharon Springs, KSN60233C-150j LLC · Manchester, MIN6023JR&M Steel Co · Caldwell, IDN6023SChristiansen Aviation LLC · Wilmington, DEN6023VChristiansen Aviation LLC · Wilmington, DEN60249Bas Part Sales LLC · Greeley, CON6024EDhs Operations LLC · Wilmington, DEN6024JHangar 5 LLC · Wilmington, DEN6024TDouglass Bruce · Conway, MA
Back to AD 79-10-14 R1