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.
N7607FRolinski Alexander S · Deland, FLN7607GOwens Wilbur · Rch Palos Vrd, CAN7607SBelle Valle Aviation LLC · St Petersburg, FLN7607TVantine Willard W III · Lexington, SCN7607XHall Douglas F · Pembine, WIN7608FAj Mush LLC · Dearborn, MIN7608MInspiration Aviation LLC · Mesa, AZN7608SMkc Flying LLC · Gladstone, MON7608XStanton Todd D · Plains, KSN76091Riverside Flight Academy Inc · Riverside, CAN7609FKomberec Eric R · Kalispell, MTN7609MYoung Robert D · Georgetown, DEN7609QPierson Janice R Trustee · Scio, ORN7609SButzbaugh Elden W Jr · Saint Joseph, MIN7609THall Donald P · Anacortes, WAN760BWBridgewater State University · Bridgewater, MAN760CAMcculloch Matthew L · Stoutland, MON760CPCivil Air Patrol · Maxwell Afb, ALN760JATextron Aviation Inc · Wichita, KSN760LADna Flight LLC · Hillsboro, ORN7610CSawtooth Flying Service Inc · Mccall, IDN7610GFalconer Robert H · Yolo, CAN7610MEickhoff Steven M · Fountain, MNN7610TDines Stephen R · Monument, CON7611FGeneral Aviation Support Corp · Rosamond, CAN7611GStaunton Curtis J · Tulelake, CAN7611SMile High Advertising Inc · Doylestown, PAN7612GSwartwood Thomas C · Everson, WAN7612KDeblack Richard B · Crosslake, MNN7612MHall Adam Patrick · Borrego Springs, CAN7612TBabcock Douglas O · Chesterton, INN7614VTucker Aviation LLC · Kalispell, MTN7615AUpton Michael James · Anchorage, AKN7615GWashington Samuel C · Washington, DCN7615NHelms Aviation Inc · Long Lake, NYN7615TN Maple LLC · Kalispell, MTN7615XEagle Flight Inc. · Fremont, NEN7616KHarrison William Thomas · West Richland, WAFirst renewal noticeN7616MGriffin Robert L Jr · Washington, NCN7616NFox Tim · Obion, TNN7616UShepard Gregory W · Fort Myers, FLN76172Rjd Flight LLC · North Canton, OHN76177Brown Emily D · Niceville, FLN7617URikki Air LLC · Clarksville, TXN76182Vaughan Steven T · Overland Park, KSN76185Snell Marion Lea · Ackerly, TXN7619GMercer Aviators Inc · Princeton, WVN7619NAir Alday LLC · Pompano Beach, FLN7619XWeitzel Claus P · Newington, GAN761AFranz Construction Inc · Sidney, MT
Back to AD 79-10-14 R1